Sound device/driver

[Leon]

Hi,

I have a database table contains a field that has data 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 a 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.

[John Bell]

Hi

Your problems stems from your database is not normalised. You can either
normalise the data and do a simple, query on the resulting information, or
you can iteratively search for occurences in the string.

My favoured option would be to redesign the database. Check out the
following:

http://www.algonet.se/~sommar/arrays-in-sql.html
http://users.drew.edu/skass/sql/ListToTableProc.sql.txt

John

"Leon" <pe*******@hotmail.com> wrote in message
news:89**************************@posting.google.c om...

Hi,

I have a database table contains a field that has data 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 a 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.