Posted by metcarob on 09/15/05 13:02

Hi,
I have the following query: (Simplified version for testing)

SELECT IIF(MonAM='S','YES','NO') as IsSick
FROM tblAbsence

This works prfectly in Access, SQL Server won't like it.
I have tried every alteration I can think of but still nothing.
This is so simple I can't believe I can't get it working.
Can anyone tell me what's wrong and let me know what I should be doing
to obtain this functionality?

Thanks
Robert

[Back to original message]