> Question is how do I declare the functions in FB ?
> I tried copying some text from the .sql file and running it in a
> command window (FlameRobin)
>
> DECLARE EXTERNAL FUNCTION lower
> CSTRING(255)
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
>
> but I get the error message "Token Unknown" which is referring to
> "lower".

Since FB2, LOWER is standard built-in function, you do not need
to use such UDF. (and if you insist, you would have to use different name)

Ivan
http://www.volny.cz/iprenosil/interbase/