Trying to use "where in" to select from a list

A simplified example: my table has two columns, data (varchar) and Contents (varchar). I want to store a list of integers in Contents, e.g. '1,2,3,4,5', and do a query like

select data from mytable where 2 in contents;

But this setup doesn't give the desired results; apparently, a comma-delimited list in a column can't be used in a "where ... in" query this way.

Is there a simple way to accomplish this? Or do I need to have to re-organize my tables?

Thanks,

Jonathan Ellis

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 16:22:39 CST