Subject Doubts about exists predicate
Author Tanmoy Ghoshal
Hi All,

I am using Firebird 2.1.3. I have some doubt about
exists predicate, can we directly use (if yes, then how, pl need an
example) as follows:

Select Field1, Field2 from Table1 where Field3 IN ('Value1', 'Value2', 'Value3');

can we use Exists predicate in above sql instead of IN, provided values
will be given same, as it is given in above sql like 'Value1',

Second doubt there value limitation for IN predicate as 1500, is there any limitation for Exists predicate?

I am beginner to sql, pl let me know.

Thanks In Advance.


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