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!
Solved! Go to Solution.
How do you get on if you replace the bottom line with this?
AND RPPO != ''
I did try this but didn't work out.
@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.
Actually that worked! I forgot to put space between the quotation marks. Thank you so much for your help!
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! :)