Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Query
Is the datatype of the field string??
How would you like the query to show "1,3/3,0/30,0/2,1/4,2", provide an expample
penghao98_at_hotmail.com (Leon) wrote in message news:<89a0a7de.0310010657.54ac116d_at_posting.google.com>...
> 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.
Received on Wed Oct 01 2003 - 14:49:56 CDT