Hi,

Use COALESCE. SELECT COALESCE(TRIM(NULL),'') FROM RDB$DATABASE

Gabor

2010.10.06. 9:42 keltezéssel, Elmar Haneke írta:

> In FB 1.5 I did use an UDF for Trim() functionality. This UDF did
> Trim(null)=''.
>
> In FB 2.x Trim is an internal function which does Trim(null)=null.
>
> How can I make the internal function act as my UDF or how can I overoad
> the internal function with my UDF?
>
> Elmar