Use the CASE function.
See BOL.

"Charles Zhang" <> wrote in message
> 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?