Rob,

> Should I

> B) pass in one string parameter that has comma seperated values. I

like

> this but am not sure of the syntax required to break then numbers out
> (just using the std FB dlls)?

Consider:

CREATE PROCEDURE TEST(
ID_List VarChar( 10000)
) RETURNS (
...
)
AS
Declare Variable SelectStatement VarChar( 20,000)
BEGIN

SelectStatement = '
SELECT
...
FROM
Table
WHERE
ID in (' || ID_List || ')';

FOR
EXECUTE STATEMENT SelectStatement
INTO
...
DO
BEGIN
...
SUSPEND;
END
END



Sean