At 06:37 PM 16-07-02 -0300, Rodrigo Albanaz wrote:

>someone knows the correct declaration of function INITCAP??
>
>it capitalizes the firs letter of a word and makes all other characters
>lowercase.

I'm not familiar with this UDF...but look for the declaration in the *.sql
file that should be with the library containing your function.

Alternatively, try out the ProperCase function in the FreeUDFLib:

declare external function f_ProperCase
cstring(254)
returns
cstring(254) free_it
entry_point 'ProperCase' module_name 'FreeUDFLib';

heLen

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