Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL Help
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
![]() |
![]() |