VARCHAR to NUMBER
From: Marc Ottone <marc.ottone_at_cjb.ville-ge.ch>
Date: Mon, 5 Feb 2001 19:14:00 +0100
Message-ID: <3a7eee26_at_news.unige.ch>
Date: Mon, 5 Feb 2001 19:14:00 +0100
Message-ID: <3a7eee26_at_news.unige.ch>
Hi,
[Quoted] [Quoted] 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
[Quoted] [Quoted] What would be the simple way to do this?
[FORMS 6i / Rdb 7]
TIA,
Marc
PS:
[Quoted] 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 - 19:14:00 CET