List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 26 2001 10:03pm
Subject:RE: Problem with query
View as plain text  
At 15:54 -0600 10/26/01, Brendin wrote:
>Yours is the first and the winner! :)  Thanks using is null worked in
>the query... Do you know why = doesn't work?

NULL basically means "unknown value", so saying WHERE x = NULL cannot
work, even if x is NULL.  That means "where one unknown value = another
unknown value", which cannot be evaluated with any certainty. :-)
Thread
Problem with queryBrendin26 Oct
  • RE: Problem with queryRavi Raman26 Oct
    • RE: Problem with queryBrendin26 Oct
      • RE: Problem with queryPaul DuBois26 Oct
        • Re: Problem with queryCarl Troein27 Oct
          • Re: Problem with queryjim barchuk27 Oct
            • Re: Problem with queryPaul DuBois27 Oct
              • Re: Problem with queryjim barchuk27 Oct
RE: Problem with queryAndrew Murphy29 Oct