"in" query

[robojob]

Hi,

I have a col in my DB that has comma seperated values, eg. 2,17,5,6

i want to query the db with a single variable and pull out all records where that value is present in the comma seperated string...

i am sure that this is an "in" query but cant get it to work...

some of the rows might only have a single number in them.

Any ideas?

[Fumigator]

Show us what you're tried.

[StupidRalph]

I have a col in my DB that has comma seperated values, eg. 2,17,5,6

First mistake. See. http://www.guelphdad.wefixtech.co.uk/sqlhelp/lists.shtml
Any ideas?
Normalise your database.