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?

I've been googling a lot, but found nothing... It seems to be tricky to google something like "firebird select in" !

If I can't send the list as a parameter, wich other method would you recomend?

thanks!

Sergio