SQL Server Performance Forum – Threads Archive

compatibility with iif in access

i have a view in which i have used iif-function. since sql server 2000 does not support iif what is the posible alternative

You can create a custom function, that will work like iif. — "Recommended By Dr. Audioscrobbler."
http://www.audioscrobbler.com/user/chopeen/

Have a look at CASE in BOL. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

CASE is more powerful than iif Madhivanan Failing to plan is Planning to fail

]]>