I'm not sure I understand your question, but my interpretation would be solved like this select * from table where variable in (select id from tablefield1) I hope this helps you!! Natalie On 9/16/06, Hassan <aldoyh@xxxxxxxxx> wrote:
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
