On Fri, 21 Mar 2008 12:03:51 +0100, "J.O. Aho" <user@example.net>
wrote:

>SELECT COUNT(*) AS Times, <column> FROM <table> GROUP BY <column> HAVING
>Times>1 ORDER BY Times DESC;


Great. I was able to clean up my data considerably with that
syntax. Thank you very much.


Is there any way to find records in a table that has one field
of a table is NOT a subset of another field ignoring the case
altogether?

For example:

Field 1 Field 2
as John turns around JOHN
Garry lost his watch Gerry


The first record (JOHN) would be a match. Therefore, it would
NOT be returned. Therefore, it would NOT be returned in the query.

The second record (Gerry) would not be a match because Garry
is not equal to Gerry. Therefore, it WOULD be returned in the query.
I'm looking only for records that field 2 is not contained in
field 1.

Regards,




Fred