Change <blank> value in SQL Reporting to 999

I am creating a report using visual studio and I have fields that are blank. In my statement I want to change these blank values to 999. Here is my sample statement.

SELECT GL_CODES
FROM GL_TABLE

What I think:  
SELECT iif(GL_CODES,?,?)
FROM
allenkentAsked:
Who is Participating?
 
ThomasianConnect With a Mentor Commented:
Assuming GL_CODES is numeric:
SELECT ISNULL(GL_CODES, 999)

Open in new window

If GL_CODES is char/varchar:
SELECT CASE WHEN GL_CODES > '' THEN GL_CODES ELSE '999' END

Open in new window

Alternatively you can also change the value of the text box control
=IIF(ISNULL(GL_CODES), '999', GL_CODES)

Open in new window

0
 
allenkentAuthor Commented:
Perfect Answer...
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.