Is there a restriction on the use of this clause? Do the elements between the ( and the ) have to be literals?

I had a field with up to 9 values, and I wanted to do

where table.field in (:opt1, :opt2. ... :opt9)

but script kept getting compile errors. My old manual shows only literals between the ( and the )

By the way, :opt1 ... :opt9 were globbal enums.

I did solve it the hard way with a series of or clauses.

Les. Satenstein 4c4 informix.

Re previous posting

Hi Leslie,

You should have ticked the box 'disable smilies in text' when posting because the string :o translates into a smilie otherwise. I have done this for you now. See also How to avoid unwanted smilies