Subject Question
Author hans@hoogstraat.ca
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;

END

but can say

WHERE NUMBER IN ( '1,2,3' )

Best Regards
Hans