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