Query Problem with Lists

[Eric Scuccimarra]

I have a table where one field is a long list of numbers in comma-delimited 
format.

I need to do a query like:
SELECT  *
FROM            Table
WHERE   [number] IN list
If I cut and paste the actual list in it works fine but when I use the 
column-name containing the list it returns nothing. I've been searching the 
MySQL docs for hours and haven't turned up anything. Apparently I can use 
set functions but the lists seem to be too big to store as sets.

Any help is appreciated.
Eric

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]