Find Dups On Category:
SELECT
A.Category
A.CategoryID
FROM
CategoryList A,
CategoryList B
WHERE
A.Category = B.Category
AND A.CategoryID <> B.CategoryID
order by ACAT
At 12:11 PM -0400 5/14/2000, stas wrote:
>Hello,
>
>Does anybody have a quick code snippet to find possible duplicates based on
>one db field, case-insensitive? Thanks.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.