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,