Re: number only

 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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx[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@xxxxxxxxxxxxx','','','')
   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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: