hi
i am trying to create a view in sql server 2000...
in my select statement i want to use iif() function , but it gives a error.

my syntax is select iif(xfield1 = 1,xfield1,xfield2) as new_field_name

but this gives an error.....
pls let me know how to use iif() function in sql server

thanx