Re: Oracle/SQL - Help

On Tue, 18 May 2004 17:36:08 GMT, Bricklen <bricklen-rem_at_yahoo.comz> wrote:

>Jay wrote:
>
>> 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
>Apply a TO_NUMBER function to it:
>select * from <table> where to_number(prev_val) <= '10' and
>to_number(curr_val) > 10;
>
>(if I've understood correctly what you are asking for)

Of course, with the to_number function, you *don't* want to put the comparative vaule in quotes! ;-) Received on Wed May 19 2004 - 07:52:32 CDT