nigerman
asked on
How to Convert Access IIF to SQL Server CASE WHEN...END
Greetings again.
One last conversion request, please.
Ok, one more and I will be done with the conversion issue.
ranking = "IIF(last_name='" & lname & "',20,0)"
I need to convert to legal sql server code.
I have tried:
CASE WHEN last_name = '" & lname & "' THEN 20,0
I know that doesn't make much sense.
Any help appreciated.
One last conversion request, please.
Ok, one more and I will be done with the conversion issue.
ranking = "IIF(last_name='" & lname & "',20,0)"
I need to convert to legal sql server code.
I have tried:
CASE WHEN last_name = '" & lname & "' THEN 20,0
I know that doesn't make much sense.
Any help appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is incredibly impressive.
Thanks very much