Oracle/SQL - Help

All,

I have two fieds defined in a table as follows

prev_val varchar2(200);
curr_val varchar2(200);

I have following data in that table.

prev_val            curr_val
19,2                 64
64                   2000
9,6                  19,2    <<<---  Need to retrieve this row
0                     9,6

( comma is the decimal point here )

I need to run a query with where clause like this:

and prev_val <= '10'
and curr_val > '10';

or

and prev_val <= 10
and curr_val > 10;

Obiviously the current scenerio won't work? How can I achieve this without altering the table?

TIA J Received on Tue May 18 2004 - 12:30:23 CDT