Well, Luciano, it is good to hear that you are satisfied, but the plan
reported by IBExpert does indicate that something still is wrong. But, that
is your problem and if neither you nor your customers discover it, then you
may get by without fixing it. And I do not know Firebird well enough to say
that your select gives you wrong results, just that the plan indicates that
it is trying to do something you never intended it to do.

Set

At 14:14 20.06.2003 +0000, you wrote:

>Thanks Set.
>I checked the Charset in our customer and the it was
>set as NONE by the implementation people and here it`s
>WIN1252, I changed back to NONE and it`s all right now.
>
>Thanks you all for your help!