Sometimes
asked on
IIF Statement in SQL
I would usually use the following statment in microsoft access, however I can't get it to work in SQL server any ideas
SELECT IIf([AddressedDate] Is Null,[TargetDate],[Predict edCompleti on]) AS [Order], * FROM Tjobrecord;
Thanks
SELECT IIf([AddressedDate] Is Null,[TargetDate],[Predict
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER