Page 1 of 1

NULL value using eSQL

Posted: Thu 11 Feb 2010 15:45
by 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

Posted: Fri 12 Feb 2010 14:24
by 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;