RTF SQL Reference, functions, TRANSLATE(). With a pinch of DECODE(LENGTH(),
0, 999, ...) it should do.
Regards,
Stephane Faroult
On Wed, 30 Jun 2004 14:34 , 'Oracle' <oracle_list_at_hotmail.com> sent:
I have a column with data such as :
abc123
123
abcde
I want to write a query which returns only numbers from the column , if
there are none, then default to 999
So i would have:
123
123
999
Any ideas on the syntax?
Thanks
Please see the official ORACLE-L FAQ:
http://www.orafaq.com[1]
To unsubscribe send email to: oracle-l-request_at_freelists.org[2]
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/[3]
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html[4]
- Links ---
1 modules/refer.pl?redirect=http%3A%2F%2Fwww.orafaq.com
2 javascript:parent.opencompose('oracle-l-request_at_freelists.org','','','')
3 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Farchives%2Foracle-l%2F
4 modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fhelp%2Ffom-serve%2Fcache%2F1.html
Please see the official ORACLE-L FAQ: http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Jun 30 2004 - 08:37:25 CDT
