> Hello! I have a simple SP with something like this:
>
> select my_field
> from some_table
> where id in (1,3,56,100)
>
> How can I do to pass "(1,3,56,100)" a an input parameter?

You can pass the IN list as a string, build the SQL statement <sql_text>
dynamically and execute the SQL with:

[FOR] EXECUTE STATEMENT <sql_text>;



--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/