Re: VARCHAR to NUMBER

Hi

select
 to_number
   (translate

      ('X -123b'


       ,'1'||translate


          ('X -123b'
          ,'a1234567890'
          ,'a'
          )


       ,'1'

      )

In article <3a7eee26_at_news.unige.ch>,
  "Marc Ottone" <marc.ottone_at_cjb.ville-ge.ch> wrote:

> Hi,
>
> In order to select data (block based on table) I need to get NUMERIC

> 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
>
> Marc Ottone
> Conservatoire et jardin botaniques de Genève
> marc.ottone_at_cjb.ville-ge.ch
>
>

--
Stax



Sent via Deja.com
http://www.deja.com/