""csswa"" <csswa@...> wrote in message
news:a9627g+4j2c@......

> Claudio, the declaration for this udf is:
>
> declare external function udf_snvl
> varchar(100) by descriptor, varchar(100) by descriptor,
> varchar(100) by descriptor returns parameter 3
> entry_point 'sNvl' module_name 'fbudf';
>
> Can the varchar(100) be made higher, e.g. varchar(200)?

Use 500 if you like in all parameters. However, remember to cast any
non-string argument to char or varchar or you will get garbage.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing