List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 29 1999 9:05am
Subject:Re: math problem with multiple que
View as plain text  
A further note regading comparisons with NULL ...

On Mi, 1999-07-28 20:20:19 +0200, Christian Mack wrote:
> > where
> >        function=1 and lc.criteria!=null
                          ^^^^^^^^^^^^^^^^^

Because NULL is no normal value this comparison doesn't work!

Use:      NOT ISNULL(lc.criteria)
 or:      lc.criteria IS NOT NULL     <-- this being my favourite
 or:      NOT (lc.criteria IS NULL)
... whatever you like most.

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

Ciao,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
math problem with multiple queGeocrawler.com28 Jul
  • Re: math problem with multiple queChristian Mack28 Jul
    • Re: math problem with multiple queMartin Ramsch29 Jul