NULL value using eSQL

[ies]

Hi, i'm using eSQL and i have a question

1.- ?Is possible use NULL value?

Can you show me an example?


thank,
________
Vapor Genie Vaporizer

[AndreyR]

Here is a simple example:

Code: Select all

SELECT VALUE department FROM Depts as department WHERE department.Loc LIKE 'test' OR Department.Loc IS NULL ORDER BY department.Dname ASC;