> Is there a way to have a parameter for an 'in' clause that expands to a
> string?

I solved that with help of a small udf:

select * from t_table t where
f_ibpparseint(t.artikelnr,:artikel)=1 and
f_isparentstr(:stichw,(select stichwort from t_artikel a where
a.nr=l.artikelnr))=1

e.g. f_ibpparseint( 1 ," 1 , 2 , 3 ") returns 1

e.g. f_ibpparsestr( "TEST" ,"IBO , DELPHI , WORLD ") returns 0

Mit freundlichem Gruss & Best Regards
Andreas Pohl
ibp consult