I'm trying to write a pass-through query that contains anumber of IIf statements. SQL Server doesn't appear to like them.

Can anyone please tell me what the syntax should be or what function to use in their place?


Thanks.

Case When ....
When ...
When ...
Else ...
End

Thanks!

Do you happen to know whether there is an equivalent of the nz() function as well?

ISNULL(Column,ValueToReturn if null) as ColumnAlias