Re: Oracle/SQL - Help

Hi Bricken,

Thanks for the tip. I am getting invalid number when I use to_number function... Is the comma as delimiter causing it?

Thanks again

Jay  

Bricklen <bricklen-rem_at_yahoo.comz> wrote in message news:<cQrqc.19951$j6.19721_at_edtnps84>...
> 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)
Received on Tue May 18 2004 - 23:26:48 CDT