Use the "" syntax
If the source table for a gateway sql query has null values and you would like to filter these out, you can use the query:
select * from T1 where ID <> ""
where T1 is the source table.
Resulting dataview in gateway sql sampler: