Ann,

Thanks for your reply.

> > select noteid, folderid, subject, count(*)
> > from dbnotes
> > group by noteid, folderid, subject
> > having count(*) > 1
>
>
> Err, if you group by the primary key, you're seldom going to find a
> group with more than one member. Here's an alternative:
>
> select a.noteid, a.folderid, b.noteid, b.folderid, a.subject
> from dbnotes a
> join dbnotes b on (a.subject = b.subject)
> where a.noteid < b.noteid

The above returns the following error:

ISC ERROR CODE:335544652

ISC ERROR MESSAGE:
multiple rows in singleton select

Let me review what I'm trying to do.

I'm only searching one table: dbnotes.

This is a new table created by merging many tables from another db.

There are a very few duplicate fields for <subject>.

I need to find those to evaluate which one to keep.