Roger,
Could you take this to the ib-support list please?

Thanks!
Helen
(mod)

At 03:39 PM 05-06-01 +0100, you wrote:

>I have a straightforward name & address table,
>each record has a unique ID (primary key)
>
>I need to identify the ID of those records
>that are duplicated across the name and address
>fields, possibly with some degree of mismatch (ie
>a %LIKE% element)
>
>Cannot figure out the SQL at all as COUNT
>just tells me I have duplicates, not which
>they actually are
>
>Regards
>
>
>Roger Pullen
>
>Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________