BarneyL (6/28/2013)
While I wouldn't trust the results without checking them by eye (or expect all cases to be found) DIFFERENCE can be used as a quick and dirty way of identifying a short list of possible duplicate records.
I actually had to script something with a similar objective quite recently, and it didn't even occur to me to use this approach. I think I'll revisit that, thanks!
ron
-----
a haiku...
NULL is not zero
NULL is not an empty string
NULL is the unknown