COMMON FIELDS

Hi,
Can anyone advise the best way to pull a common string (if any) from a feild in a table. They will be grouped by another field. I plan to append results to a table.
e.g.

INPUT TABLE

PK            GROUP
M100A       M
M100B       M
M100C       M
ABCD1       A
ABCD2       A
ABCD3       A
BG456       H
AFCG       H
ACFE       H

OUTPUT TABLE
COMMON STRING GROUP

M100                             M
ABCD                             A
**NONE**                    H

Thanks very much,
Allan Received on Fri Apr 19 2002 - 08:24:14 CDT