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