Concatinate Value Into New Column Upon Select

Hi,

I'm new to the forum, and semi new to sql, I've been working with
it for about 1 year now, but from a programmers side. I simply
just plug in my selects, and inserts, but most of my work is in
asp.net. I apologize if I have posted in the wrong forum section.
Here is my problem....

I have a table that has the follwing columns..
UserName, question1, question2, Id

question1 and question2 columns simply hold either 'Y' or 'N'
Meaning that the user either answered Y or N for the questions.

I'm trying to create another column on the fly... example....

select *,
[othercolumn] = case question1
when 'Y' then 'question1,'
else ''
end
from mytable

If both questions1 and questions2 have the column value of 'Y', then
the othercolumn should have 'question1,question2' as the end of the above select.

The above example only works for checking for question1, but I will need
to do the same for question2 and concatinate that into the othercolumn column.

I hope, I have explained myself well.
Please let me know if you need more info from me.