At 04:05 AM 19-07-02 +0000, you wrote:

>Hi,
>
> How to attach the fbudf to the database. I am using
>FB 1 on W2k.

1. Place the dll in your {firebird-root}\udf directory if it's not already
installed there
2. Pick up the declarations for the funcs you want to use by copy-pasting
from fbudf.sql into a script or other DDL interface, and commit.
3. After that, just use the functions.

> is there any docs on internal functions like
>SUSBSTRING?

Internal funcs inherited from InterBase are in the InterBase docs
(LangRef.pdf, SQL Statement and Function Reference)

New funcs added in Firebird only are documented in the Release Notes.

All Firebird internal funcs and all of the funcs in fbudf are documented in
the Firebird Reference Guide (currently available to IBPhoenix CD
subscribers as a beta document).

>Are there any other functions like this ?

There are not a lot of string functions in FB/IB because they tend to be
implemented in UDFs. Look at some of the other UDF libraries as well.

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________