Problems with Null values

When I execute a query with a condition: date = Null I don’t obtain any result. But when I execute the same query directly with isql I get some results.
Is there anyone there who had the same problem or who has an idea ? Thank you for your responses.
Ouarda Boudour
Amadeus France


Listserv Archives (BOB member since 2002-06-25)

Try ‘date Is Null’ i.e select ‘Is Null’ option in the conditions

Sudha

— Ouarda BOUDOUR oboudour@AMADEUS.FR wrote:

When I execute a query with a condition: date = Null I don’t obtain any
result. But when I execute the same query directly with isql I get some results.
Is there anyone there who had the same problem or who has an idea ?
Thank you for your responses.
Ouarda Boudour
Amadeus France

__________________________________________________ Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. http://messenger.yahoo.com


Listserv Archives (BOB member since 2002-06-25)