Subject Re: [firebird-support] 'IN' problem
Author Ann W. Harrison
Nick Upson wrote:
> should I expect it to work if I do something like
> stmt = 'select count(*) from .....NOT IN (' || str || ')'
> execute immediate stmt

Yes - that's what you have to do. The processing involved
in preparing a statement identifies certain lexical elements -
including the elements in the IN list. You can replace values
after a statement is prepared, but not keywords, field or table
names, comparison operators, etc., and the in list is one of
the things that can't be changed.