meta data for this page
  •  

F_PROPERCASE

compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

Entrypoint propercase not compatible with UTF-8 - use U_PROPERCASE

U_PROPERCASE

function from adhoc

Entrypoint u_propercase compatible with UTF-8

Inputs/Outputs

 Input       CSTRING(32760)      String to convert
 Output      CSTRING(32760)      String with all words starting with upper, all other lower

Syntax

 Changes also umlaut. A lower "ß" stays "ß" because there is no upper "ß"
 TestSQL
 SELECT 'Dies Ist Ein Test Äh' AS ISCORRECT, F_PROPERCASE('dies ist ein test äh') FROM RDB$DATABASE;
 SELECT NULL AS ISCORRECT, F_PROPERCASE(NULL) FROM RDB$DATABASE;