Skip to main content

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 != ''

1 risposta
  1. 22 feb 2022, 14:27
    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?

0/9000