Do you consider '5', '05', '005', e.t.c. duplicates or not?
>
>I have a table with the current rows.
>COL 1 COL2
>
>ABCD001 G
>ABCD002 F
>ABCD003 R
>ABCD004 Q
>ABCD005 W
>ABC001 E
>ABC002 T
>ABC003 U
>ABC009 P
>ABC008 OI
>ABCE01 PL
>ABCE02 LM
>ABCE03 MN
>ABCE09 RT
>
>I need to write a query that will return all rows that have the number
>part of the string duplicated.
>
>ie: I need to discard the letter prefixes and concentrate on the numbers.
>
>Thanks,
--sb--