Re: SQL question

I use:

  SELECT * FROM table_name
  WHERE char_column IN ('1','2', ... 'n')

Jerry

curtis_strain_at_mail.amsinc.com wrote:
>
> 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
Received on Tue Sep 30 1997 - 00:00:00 CDT