Condition where if field is Null- error

[luisguerra]

Hi Guys! I have a problem.

i have a condition "where" in my SQL: only will print data if my "DATE_FIELD" is null.

In SQL works perfectly, but in Qlik sense not works.

Can you helpme?

My Code:

In My SQL have the next sintaxis:----------------

SELECT *

FROM "table"

WHERE "date_field" IS NULL

But if i write inQlik sense: --------------------------

LOAD *;

SQL SELECT *

FROM "NOMINA_IMI".dbo."empleados_sueldos"

where  "date_field"=null;       <-- not work! retun 0

[swuehl · Accepted solution]

everything from SQL SELECT to the next semicolon will be interpreted and executed by your SQL driver.

So why don't you just use the first SQL statement that works for your?