It looks like udf_Trim in the tbudf library has a trim function that
should work. The source to the function is:

function udf_Trim(Str: PChar): PChar; cdecl; export;
begin
Result := Str;
StrPCopy(Str, Trim(Str));
end;

and the Trim function it calls trims characters from both ends of a
string that are less than or equal to a space (ASCII 32). That should
get all the whitespace.

Jack


--- In firebird-support@yahoogroups.com, "Indysoft Bt."
<indysoft.hu@...> wrote:

>
> Write your own UDF. It is the simplest way.
>
> Regards:Alex
>