SQL Server Performance Forum – Threads Archive
compatibility with iif in accessi 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. —
Microsoft SQL Server MVP
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