Hi,

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,