oracle function - get numbers from text string

From: Andy Ho <andyho99_at_MailAndNews.com>
Date: Mon, 9 Jul 2001 15:29:20 -0400
Message-ID: <3B672F10@MailAndNews.com>

Hi,

I was wondering if there is a function that can return numbers from string. For example:

'$ 4.50' - returns '4.50'
'abc 1.0 def' - returns '1.0'

There are no patterns for the string. Onle one thing for sure, there is only one number or no number in the string (if no number, return NULL).

Thanks, Andy

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Mon Jul 09 2001 - 14:29:20 CDT