Re: SQL Query

natalia.poggi_at_spm.com.ar (Nat) wrote in message news:<1155e81c.0310011149.18cf1212_at_posting.google.com>...
> 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.

The string value of one field may be something look like "1,3/3,0/30,0/2,1/4,2", I want to query out this row of record if in this string,if there are numbers seperated by a comma, left side is equal to 1 and right site is greater than 0. In this case with string value "1,3/3,0/30,0/2,1/4,2",becase there is a match "1,3", so this row of record should be query out. In case with string value of "1,0/3,0/30,0/2,1/4,2", there shouldn't be any row of record query out.

Thank you. Received on Wed Oct 01 2003 - 21:36:41 CDT