Equivalent of MS Access IIF function in SQL?

[ChrisN]

Is there an equivalent to the MS Access IIF function in SQL??

TIA
Chris

 

[rt63]

Not in SQL 7.0 - maybe in SQL2K (though I doubt) - probably can create a UDF in SQL2K.

You can also use CASE instead

select case when <some condition> then <some value> else
<some other value> end


RT

 

[paron]

I alse used IIF for handling nulls, which in SQL Server comes out like: ISNULL(MiddleName, N'(NMN)')

In this example NMN is shown if MiddleName is null.

Ron