Can't you create a table with those constants and
then use some kind of a JOIN or WHERE ?

----- Original Message -----
From: "Daniel L. Miller" <dmiller@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, November 18, 2010 11:10 PM
Subject: Re: [firebird-support] Doubts about exists predicate


> On 11/16/2010 1:44 AM, Tanmoy Ghoshal wrote:
>> Hi Set,
>>
>> Thank you for reply.
>>
>> I have more than 1500 constant values. Here IN not accept more than
>> 1500, then
>> what is the best way to write SQL to get data in less time.
>>
>> I need to write SQL which should not take much time to execute.
>>
>> As a beginner, If possible Please help me
>
> You said you have more than 1500 constant values. Are these values
> actually constant - they do not change between program runs?
>
> --
> Daniel
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>