Use the CASE function.
See BOL.

"Charles Zhang" <crazy_legselong.com> wrote in message
news:00a301c34579$9e51b4a0$a501280aphx.gbl...
> Hi,
>
> I want to create a column in a view that is based on
> columns in a particular table. I want to create this new
> column using If statements. I know I can do this in
> Access, can I do this in SQL Server?