Compare a given value with multiple values field

[Hassan <aldoyh@xxxxxxxxx>]

Hi My Best List, I have a field in a table contains "3,31,11,10" (let say tablefield1) and I have a given value which I need to check if it exists in that list.
   
  I've tried:
  SELECT * FROM table WHERE 3 IN ( tablefield1 );
   
  Any ideas?

 		
---------------------------------
Get your email and more, right on the  new Yahoo.com