Help - Using parameters in SELECT statements

Am trying to compare a numeric value against a list of values to in a SQL Statement in a PL/SQL stored procedure using IN. Am using SQL Windows as a front end and submitting the values as a comma-delimited string (i.e. '3,4,5') but cannot do because PL/SQL will literally translate this in the where clause and compare its numeric key as follows:

WHERE excpt_ID IN ('3,4,5')

Cannot send the parameter from SQL Windows without the single quotes because it will treat the values as additional parameters. also, for some reason, stripping out the single quotes did not work ---

thanks in advance for any help

s.fletcher
terrace systems corporation Received on Tue Feb 11 1997 - 00:00:00 CET