SQL question

I am trying to do the following sql statement:

SELECT * from tbl_name
WHERE number_column IN (host_variable_of_string_type);

I got syntax error. The host_variable_of_string_type variable looks like: "1,2"

How can I do this? Thanks in advance for any suggestions!

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet