Charity.....
Huston... we have a problem! Calm down... a small problem with terminology perhaps.
...........3)Duplicate records where one or two records may have nfiles isnull and another record where nfiles=1 or nfiles=2... (Within the duplicate set of records, only ONE will have nfile notnull, this is the IMPORTANT record, if lose this I'll be screwed)
In your thoughts what is null and what is non null?
There is a difference between null and empty or blank.
Tom Gahagan
Alliance
Computer Solutions
"Music, like sex, is much too important to be left to professionals."
Robert Shaw