Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Help

SQL Help

From: Lawrence J. Rizzo <lrizzo_at_pce.net>
Date: 1997/06/04
Message-ID: <3395B03A.122C@pce.net>#1/1

Hello,

I am having trouble in Oracle 7.3 SQL. I have a VarChar2 column that sometimes contains numeric information and other times string. I need to query the column for numeric values in a given range. I cannot seem to find a function / method to allow me to do something like:

SELECT EDI_PO_NUMBER
FROM EDI
WHERE VAL(EDI_PO_NUMBER) BETWEEN 102 AND 119; I know VAL is not a valid Oracle function but if the BASIC equivalent of VAL was available it should work.

I did try using TO_NUMBER but no luck as I get a run time query data mismatch error.

Any ideas?

Larry Rizzo
lrizzo_at_pce.net Received on Wed Jun 04 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US