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

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

AND RPPO != ''