On 1 Oct 2001, at 22:46, hans@... wrote:

> How do I resolve the fact that I can't pass '1,2,3' in NUMBERS
>
> CREATE PROCEDURE TEST (NUMBERS VARCHAR(30))
> RETURNS ( NAME VARCHAR )
> AS
>
> BEGIN
> FOR SELECT NUMBER FROM TABLE
> WHERE NUMBER IN ( :NUMBERS )
> INTO :NAME DO
> SUSPEND;

try this

select number from table
where :numbers containing number



Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz