Finally I came with a conclusion about the query without RTRIM.
The one with RTRIM uses Plan(Conturi Natural), the one without RTRIM uses
the index PLAN (Conturi INDEX (RDB$PRIMARY3))
Apparently it's the index's fault....

I backup the database and restaure it without any change...

/* this one works */
select max("Cont") from "Conturi" where "Sintetic"='D' and '411.1' starting
with RTRIM("Cont");

/* this one do not */
select max("Cont") from "Conturi" where "Sintetic"='D' and '411.1' starting
with "Cont";

"Cont" is VARCHAR(30)


Adrian Roman

----- Original Message -----
From: "Adrian Roman" <aroman@...>
To: < >
Sent: Tuesday, July 30, 2002 7:38 PM
Subject: Re: [ib-support] Is this a valid query? It seems so, but it doesn't
return anything


> Oops!
>
> Make it
>
> select max("Cont") from "Conturi" where "Sintetic"='D' and :"Cont"
starting
> with RTRIM("Cont") into :"Sintetic";
>
> The first RTRIM was useless, of course
>
> Adrian Roman
>
>