Re: Difference between = and IN

From: Andy (Andy_at_discussions.microsoft.com)
Date: 02/08/05

  • Next message: Steve Kass: "Re: LIKE or CHARINDEX algoritms" 
    Date: Tue, 8 Feb 2005 03:31:03 -0800

    Hi Hugo

    That's a relief I didn't fancy having to re-check all my databases!!! Its
    also nice to know I'm not a complete eejit!

    Thanks for your help

    Andy

    "Hugo Kornelis" wrote:

    > On Mon, 7 Feb 2005 07:19:02 -0800, Andy wrote:
    >
    > >Hi Hugo
    > >
    > >I misunderstood what you meant in the previous post. I have worked out in
    > >the past that you have to use 'IS [NOT] NULL' rather than '<> Null' (or 'IN
    > >Null' or '= Null'). I thought you meant that NOT IN (1,2) would return
    > >strange results if Nulls were present in the records whereas (I believe) NOT
    > >IN (1,2) would return all rows that did not contain a 1, 2 or Null.
    >
    > Hi Andy,
    >
    > That's correct. It's good to see that you know that rows containing NULL
    > will not be returned be NOT IN (1, 2) - this is also a hefty surprise for
    > many people!
    >
    > Best, Hugo
    > --
    >
    > (Remove _NO_ and _SPAM_ to get my e-mail address)
    >

  • Next message: Steve Kass: "Re: LIKE or CHARINDEX algoritms"

    Relevant Pages

    • Re: The Doctor And Escherichia Coli
      ... inherit the databases. ... Andy, have a visual thing. ... belong it. ... It keeped, you bended, yet Ramzi never daily centred ...
      (rec.games.roguelike.nethack)
    • Re: Isinteg and Eseutil
      ... > accounts from our databases plus our backups are taking forever. ... > why I want to use eseutil to shrink the database. ... >> try defraging and other stuff. ...
      (microsoft.public.exchange.admin)
    • Re: Query Help with IF stmt
      ... Hi Andy, ... I suspect that the EmpName column in reality won't hold ... Some rows of sample data. ... Best, Hugo ...
      (microsoft.public.sqlserver.mseq)
    • Re: Which Version of Access
      ... dynamically generated report). ... But I also want to protect the back end databases from being opened directly ... > Andy wrote: ...
      (microsoft.public.access.modulesdaovba)
    • Re: Difference between = and IN
      ... I misunderstood what you meant in the previous post. ... strange results if Nulls were present in the records whereas NOT ... "Hugo Kornelis" wrote: ... > Hi Andy, ...
      (microsoft.public.sqlserver.mseq)