I have a SQL report created in SAP, which has "where " condition to only show records having null in a field.
Select Field1, Field2, Field3
where Field1 is null
The query works fine in SAP and SQL server management studio.
I am trying to create the report in Crystal reporter, but the syntax of Null is not accepted.
I have tested that
Those records with no value in the field just didn't display ...
What is the right Syntax to use?