hello Helen,

> in (1,5) or
> in (1, 5) give a strange behaviour:

apart the other forms already described, maybe there was a little
misunderstanding for this form. With the above quoted sentence I didn't
mean:

where var in (1,5) or var in (1, 5)

but I meant that:

where var in (1,5)

or alternatively

where var in (1, 5)

both with a space after the "in" and the latter with a space after the
comma, produce the behaviour described in my previous message.

Since I'm testing a TIB_SearchPanel, I meant typing in the field one or the
other, and not both. I know that

"in (1,5) or in (1, 5)"

as a SQL statement is a nonsense :-)

Cheers
Salvatore