IIf Statements in access

What would be the easiest way to convert the IIf statement in the my access select string to a stored procedure in sql select.
rvindustAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Victor SpiridonovConnect With a Mentor Commented:
USE CASE statement

IIF(a>b,a,b) will translate into
SELECT (CASE WHEN A>B THEN a ELSE B END)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.