Hello!!!
Try to make PLSQL function returning number. Argument for this function can
be string with number. This function could be called even from SQL queries.
best regards
DUSAN MARJANOV
"Andy Ho" <andyho99_at_MailAndNews.com> wrote in message
news:3B672F10_at_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:44:02 CDT
