compatibility with iif in access | SQL Server Performance Forums

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."

Have a look at CASE in BOL. —
Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

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