SQL & PL/SQL

Hi,

We have usr_login attribute where most of the time it will be 6 digits. But few users are created with less than 6 digits.

column description : USR_LOGIN    VARCHAR2(256 CHAR)

Example :

002241 is the real user, but there was a duplicate user with 2241.

Now, i need to get all such users, who fall under similar issue (where string value of usr_login is not equal but numeric value is equal.  For example 002441=2441 but "002441"!="2441") .

we have users whose usr_login is not with digits. eg. HALLP, TONYUI and these users should not be included.

Any help would be greatly appreciated.

Thanks in advance