Hi Riyaz,
...from BOL:
SELECT 'Price Category' =
CASE
WHEN price IS NULL THEN 'Not yet priced'
WHEN price < 10 THEN 'Very Reasonable Title'
WHEN price >= 10 and price < 20 THEN 'Coffee Table Title'
ELSE 'Expensive book!'
END,
CAST(title AS varchar(20)) AS 'Shortened Title'
FROM titles
ORDER BY price
MartinJ
>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