IIF AND

#1

Hello.

How would I add a second condition to the IIF() function, without using
nested IIF() functions ?

i.e.

IIF(A,X,Z)

I would like

IIf(A AND B,X,Y)

Any ideas ?

Regards,
James

#2

Forget it. iif(A and B,X,Y) actually works. For some reason it didn't
when I first tried.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

IIF AND

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

IIF AND - 05-20-2005 , 05:02 AM

Re: IIF AND - 05-20-2005 , 06:44 AM