Subject Sql Expression IN Clause Limit
Author ibrahim bulut
Hi,
I am using firebird 1.5.1
i want to ask a question to firebird users.

is there any limit about "IN" clause

example
======
select field1, field2 from table1
where
(field1 in (param1, param2, param3.... paramN)) and
(field2 in (Fparam1, Fparam2, Fparam3.... FparamN))

how many params i can write to IN clause
is there any limit about IN clause


and how many characters can be sql expression length
is there any limit about sql expression length


ibrahim Bulut
ileti�im Online Ltd.�ti.
Software and Database Expert
Turkish Republic

[Non-text portions of this message have been removed]