Re: SQL Query

"Leon" wrote...
> Hi,
>
> I have a database table contains a field that has date like
> 1,3/3,0/30,0/2,1/4,2 , and I am trying to make a sql query to query
> out this record if two numbers seperated by comma, left side is
equal
> to 1 and right site is greater than 0. Is it possible? if so, how
can
> I do it?
>
> Thank you very much for your help.

Hi Leon,

yes, easy...
First hint: have a close look at following functions: INSTR, SUBSTR, SIGN, DECODE. Second hint: they're ordered from innermost to outermost. Third hint: you can use them in the WHERE clause of your query.

Have fun with it.

hth,
Guido

--
Hobbes: How come we play war and not peace?
Calvin: Too few role models.
(Bill Watterson, Calvin and Hobbes)