SQL query for empty string data type

[tectonics25]

Hi, I am trying to use a SQL query in Input tool, to get a portion of data from a server, and I need to ask for "not empty" values. the column is string, so when I use "is not null" it doesn't work. can someone help me what should I use instead to get not empty values? here is my SQL:

SELECT RPPO, RPPDCT, RPOBJ, RPSUB, RPVINV, RPDIVJ, RPLNID, RPPYIN, RPSBL, RPSBLT, RPDOC
FROM JDESTAGE.F0411_LT
where RPDIVJ>=122001
and RPPO is not NULL

Thanks!

[DataNath · Accepted solution]

How do you get on if you replace the bottom line with this?

AND RPPO != ''

[tectonics25]

I did try this but didn't work out.

[DataNath]

@tectonics25 are you getting an error message? Or it’s just leaving empty values in? Can you check what they actually are like are your empties 5 x white space for example? More info would be great cheers.

[tectonics25]

Actually that worked! I forgot to put space between the quotation marks. Thank you so much for your help!

[DataNath]

No problem @tectonics25! If this sorted the issue, feel free to mark the solution so others with the same problem can easily find it in future! :)