Hi all !
Using Firebird 1.5.
I need to put some values in variable, for later use with IN()
operator in a stored procedure.

.....
declare variable ParentIds varchar(1024)
.....

ParentIds='1,2,3,4';

select ... where "Id" IN(:ParentIds)

This return error 'Incompatible column/host variable data type.'
Any idea how to resolve this ?

if the value in variable is single - ParentIds='2' - there is no
problem.

Thanks!