Progress database syntax

Can you tell me how I should translate below Progress SQL ?

a.facility_code = ifnull(nullif(?,''), a.facility_code)
jung1975Asked:
Who is Participating?
 
jrb1Connect With a Mentor Commented:
here's a cheat sheet of progress sql syntax:

http://www.psdn.com/library/servlet/KbServlet/download/1093-102-901/e89.pdf

What are you trying to translate this to?  It is saying:

If the value being tested (in the "?") is blank or null, then facility_code doesn't get changed (a.facility_code=a.facility_code)

Otherwise, the a.facility_code is being set to the value being passed in ("?").

The "?" is a dynamic parameter marker, and must be passed in when the dynamic sql is executed.
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.