Re: VARCHAR to NUMBER

in this case TO_CHAR doesn't seems to work (ORA-01722: Invalid number) Thanks anyway,
Kind Regards,
Marc

"nick" <nick-love_at_juno.com> a écrit dans le message news: t7u6r3h5hl5h86_at_corp.supernews.com...
>
> Marc Ottone wrote:
> >
> >
> > 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
> >
> >
> > Marc Ottone
> > Conservatoire et jardin botaniques de Genve
> > marc.ottone_at_cjb.ville-ge.ch
> >
> >
> > why don't ya use TO_CHAR instead, see if that will work
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Wed Feb 07 2001 - 08:19:03 CET