| 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 query | Brendin | 26 Oct |
| • RE: Problem with query | Ravi Raman | 26 Oct |
| • RE: Problem with query | Brendin | 26 Oct |
| • RE: Problem with query | Paul DuBois | 26 Oct |
| • Re: Problem with query | Carl Troein | 27 Oct |
| • Re: Problem with query | jim barchuk | 27 Oct |
| • Re: Problem with query | Paul DuBois | 27 Oct |
| • Re: Problem with query | jim barchuk | 27 Oct |
| • RE: Problem with query | Andrew Murphy | 29 Oct |
