need sql query [message #268355] |
Tue, 18 September 2007 05:41 |
oracleram
Messages: 23 Registered: November 2006
|
Junior Member |
|
|
Hi every1,
i have empno:A123ER in table Emp,i want to retrieve only the digits 123,i need a sql query to retrive digits from alphanumeric,Thanx in advance..
Thanks & Regards,
Ram
|
|
|
|
|
|
Re: need sql query [message #268372 is a reply to message #268355] |
Tue, 18 September 2007 06:18 |
Arju
Messages: 1554 Registered: June 2007 Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
|
|
select replace translate(column_name,'ABCDEFGHIJ......',' '),' ',null) from table_name
or if you want to replace your wish
select translate(translate(column_name,'A',' '),'B',' ')..... from table_name
|
|
|