bibi92
asked on
question about iff
Hello,
I try select distinct d.LegalName, IIF ( (et.Description = 'VA'), 'YES', 'NO' ) as 'WITHOUT VA', a.* from ##CPTE a
The following error is returned :
Incorrect syntax near '='.
How can I resolve it?
Thanks
I try select distinct d.LegalName, IIF ( (et.Description = 'VA'), 'YES', 'NO' ) as 'WITHOUT VA', a.* from ##CPTE a
The following error is returned :
Incorrect syntax near '='.
How can I resolve it?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade. Good luck with your project. -Jim
ASKER