Re: VARCHAR to NUMBER

Hi Neville,

I tried TRANSLATE function but it doesn't work. Probably because of Rdb and/or PL/SQL version.
Thanks anyway.
Marc

"Neville Sweet" <sweet.neville.nj_at_bhp_xxx_.com.au> a écrit dans le message news: 95nsha$b05$1_at_gossamer.itmel.bhp.com.au...
> Hi Marc,
>
> You could use Translate, eg.
> SELECT TRANSLATE('X -123b',
> '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ -+~!_at_etc',
> '0123456789') "Num" FROM DUAL
>
> Marc Ottone wrote in message <3a7eee26_at_news.unige.ch>...
> >Hi,
> >
> >In order to select data (block based on table) I need to get NUMERIC
 value
> >from VARCHAR
> >like 'X -123b' = 123
> >and use criteria like >100 and <200
> >What would be the simple way to do this?
> >[FORMS 6i / Rdb 7]
> >TIA,
> >
> >Marc
> >
> >PS:
> >TO_NUMBER generate -01722: Invalid number error
>
>
>
Received on Wed Feb 07 2001 - 08:06:27 CET