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.

[Back to original message]