VARCHAR to NUMBER

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? 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 Received on Mon Feb 05 2001 - 12:16:43 CST