Posted by Jens on 09/15/05 13:17

SQL Server has no idea about IIF, here you have to refer to CASE. (BOL)

SELECT CASE MonAM WHEN 'S' THEN 'YES' ELSE 'NO' END as IsSick
FROM tblAbsence

HTH, Jens Suessmeyer.

• Next in forum: Re: Can someone help me with multiple "Left Outer Joins"?
• Prev in forum: Why dosn't IIF work here?
• Thread view: Re: Why dosn't IIF work here?

[Reply to this message]