Execute statement required?

In a stored procedure I need to use the following snippet of a select statement;


Is there any better way than resorting to execute statement?

BTW: How do I escape string values in execute statement?

i.e.
'where (IS_TRUE = 'Y')'

Clive.

In EXECUTE STATEMENT, I think you can just use two single quotes - this will create a single quote in the statement itself.

Yes. That turned out to be true.

I see you had no alternative suggestion to execute statement , so I will go ahead with that.

I had harboured the faint hope that in "FIRST x SKIP y" the x and y could be parametized in the same way as "COL_1 = :x"
as they seemed to have the same properties. i.e. They change the actual SQL construction, only in the way it is filtered.

Thanks,
Clive