List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 29 1999 7:19pm
Subject:Re: NULL values?
View as plain text  
On Do, 1999-07-29 12:01:38 -0700, Nathan Clegg wrote:
> How can I select on NULL fields?

Because NULL is no normal value normal comparisons don't work!

Use:      ISNULL(lc.criteria)
 or:      lc.criteria IS NULL
... whatever you like most.

Also see the manual, chapter "6.14 Problems with NULL values".

Martin Ramsch <m.ramsch@stripped> <URL: >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
NULL values?Nathan Clegg29 Jul
  • Re: NULL values?Martin Ramsch29 Jul
  • Re: NULL values?Paul DuBois29 Jul
  • Re: NULL values?Ralph Graulich30 Jul