Remove the empty or blank values in select query

Question

I am trying to exclude all null and blank in sql query,

i tried something like the below, but i still see the data ext comes with blank columns. Any adaptable keywords with SOQL is highly recommended.

AND c.xxx IS NOT NULL AND c.xxx != null and c.xxx != '' AND c.xxx != null and c.xxx != ''

Matt Pieper · Answer

c.xxx != null    is the correct syntax for filtering nulls out a SOQL query. Can you post the entire query, maybe you have a syntax issue?

Data Management