what to use instead of "if"?

[PaulSpell]

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.

 

[pdx_man]

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

 

[PaulSpell]

Thanks!

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

 

[FoFa]

ISNULL(Column,ValueToReturn if null) as ColumnAlias