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