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.
Last Comment
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASP
Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.
82K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
This is incredibly impressive.
Thanks very much