• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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.
0
rvindust
Asked:
rvindust
1 Solution
 
Victor SpiridonovCommented:
USE CASE statement

IIF(a>b,a,b) will translate into
SELECT (CASE WHEN A>B THEN a ELSE B END)
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now