Re: VARCHAR to NUMBER

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/