These functions are called external functions. They are not built
into the Firebird engine, but rather implemented inside a dll.

Inside the UDF folder in firebird, there is a file called ib_sql.dll.
This contains the trim functions you are after.

You need to tell your database what dll RTrim is located in, what the
parameter types are and how the parameters are handled. (look inside
ib_sql.sql for these commands)

For example:

DECLARE EXTERNAL FUNCTION ltrim
CSTRING(255)
RETURNS CSTRING(255) FREE_IT
ENTRY_POINT 'IB_UDF_ltrim' MODULE_NAME 'ib_udf';

Adam


--- In firebird-support@yahoogroups.com, "Milika Delic" <milika@E...>
wrote:

> >> --- In firebird-support@yahoogroups.com, "Milika Delic"

<milika@E...>

> >> wrote:
> >>> SELECT (naziv || mesto)
> >>> FROM proizvodjaci
> >>>
> >>> returns non trimmed collums like
> >>> 'moj proizvodjac backo polje
> >>> '
> >>>
> >>
> >> Select RTrim(naziv) || RTrim(mesto)
> >>
> >> mick
> >>
> >>
> nop it says unknown function RTRIM or TRIM if i tried
> or LTRIM if i tried that so....