>Probably a very easy question.
>
>I AM DOING THIS IN C#.
>
>In VFP I would have a SELECT statement such as:
>
>SELECT iif( number < 1, "NOT SET", "SET") AS status FROM ...

SELECT CASE WHEN Number <1 THEN 'NOT SET'  ELSE 'SET' END as Status from ...

>
>What is the equivalent of IIF() in Microsoft SQL 2005 in building an expression for the resultant table, or is it the same?
>
>Thank you in advance.

See http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping