> If it's a char field, you might use concatenation rather than

addition.

You're right, I should have seen that. I think I'll blame decompression
sickness from yesterday's dive :-)

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Monday, November 20, 2006 12:27 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to exclude index from plan?

Rick Debay wrote:

> I need to give Firebird 2 a hint to not use an index in the query

below.

> However, changing
> WHERE
> po.REPLENISH_GRP = ? AND
>
> To
>
> WHERE
> po.REPLENISH_GRP+'' = ? AND
>

If it's a char field, you might use concatenation rather than addition.


Regards,


Ann