Re: SQL question

Try this :

select * from tbl_name
where numtochar(number_column) in (host_var_of_str_type);

Let me know if this helped,
Chinna

curtis_strain_at_mail.amsinc.com wrote in article <875664052.9905_at_dejanews.com>...
> 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 Wed Oct 01 1997 - 00:00:00 CDT