--- In ib-support@y..., "Claudio Valderrama C." <cvalde@u...> wrote:

> What's the problem?

The problem was the column value returned from f_rtrim was 254 characters. BUT, you have solved my problem. :)

> You will notice the blanks at the tail again. And a lot of blanks. This is
> not the UDF's fault. In their infinite and awesome wisdom, Borland chose to
> convert the return of UDFs that is cstring() to SQL char instead of varchar.
> I didn't want to change that for compatibility but unfortunately, the flaw
> defeats several udfs. Any UDF returning cstring is affected. This is why I
> decided to return varchar in fbudf. And if your udf says that it returns a
> cstring(254), you will have 254 blanks minus the length of the non-blanks

The above paragraph makes it all clear now. Thank you! Any chance Firebird might choose a different path with cstring() instead of one that returns char instead of varchar? Or would this cause UDF's to be incompatible between Firebird and Interbase?

> characters. There are two solutions:

Done and done.