Re: Mission Impossible - Comparing Files
From: Jamie Collins (jamiecollins_at_xsmail.com)
Date: 10/15/04
- Next message: Thomas: "Web Site Advice Needed"
- Previous message: Brendan Reynolds: "Re: MS Access mde reversal"
- In reply to: Gary Walter: "Re: Mission Impossible - Comparing Files"
- Messages sorted by: [ date ] [ thread ]
Date: 15 Oct 2004 07:50:41 -0700
"Gary Walter" <garylwpleasenospam@wamego.net> wrote ...
> One *trivial* point on your "Amended rows"
> WHERE clause....it may not work as
> intended if either MyDataCol is Null
> and its counterpart is not Null.
That's no trival point, that's a great catch.
> I might change its WHERE clause to:
>
> WHERE
> NZ(T1.MyDataCol<> T2.MyDataCol, -1)
> AND NOT
> (T1.MyDataCol IS NULL
> AND
> T2.MyDataCol IS NULL);
Avoiding proprietary features (NZ isn't even avilable to Jet!), I'd prefer:
WHERE
T1.MyDataCol<>T2.MyDataCol
OR (T1.MyDataCol IS NULL AND NOT T2.MyDataCol IS NULL)
OR (T2.MyDataCol IS NULL AND NOT T1.MyDataCol IS NULL)
;
Jamie.
--
- Next message: Thomas: "Web Site Advice Needed"
- Previous message: Brendan Reynolds: "Re: MS Access mde reversal"
- In reply to: Gary Walter: "Re: Mission Impossible - Comparing Files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
