>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
If it's not broken, fix it until it is.
My Blog