Posted by Simon Hayes on 09/15/05 14:19

IIF exists only in Access, not MSSQL. The SQL equivalent is CASE - see
Books Online for examples.

Simon

• Next in forum: Re: Can someone help me with multiple "Left Outer Joins"?
• Prev in forum: Re: The "right" way to distribute a database to end-user
• Thread view: Re: Why dosn't IIF work here?

[Reply to this message]