Hi,

At October-06-10, 7:24 AM, Elmar Haneke wrote:

>> But if you're in a corner, I think that declaring your UDF in
>> the database will give it precedence over the internal function with the
>> same name.

> Firebird refuses the declare statement until the name Trim is enclosed
> into quotes.

> The definition with quotes is used only if the quotes are also in select
> statement - this does not help to be compatible with existing code.

Have you tried using Coalesce(Trim(Null), '') ?

This will have the same effect of the UDF Trim, that you were using.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)