query of queries NULL is not working

erikTsomik
erikTsomik used Ask the Experts™
on
I have a QoQ and i AM TRYING TO ADD a where clause
where date is null or not null but it does not work

Select * from myQuery where 0=0 and SignDate is null

but it returns all records
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

You have to keep in mind that QofQ is comparing against a stored set of data in array and structure like format.   It doesn't use a lot of database functions and concepts.

Try ...   this for is not null

 Select * from myQuery where 0=0 and SignDate != ''


and this for null...

 Select * from myQuery where 0=0 and SignDate = ''

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial