F_PROPERCASE

<< F_UPPER F_ANSIUPPERCASE U_UPPER | IBExpert UDF Functions | F_CHARACTER U_CHR >>

F_PROPERCASE
  • compatibility to FreeUDFLib, FreeUDFLibC, FreeUDFLib AvERP, GrUDF

U_PROPERCASE

  • function from adhoc
  • Compatible with UTF-8
  • Input VARCHAR(32760) String to convert
  • Output VARCHAR(32760) String with all words starting with upper, all other lower

Changes also umlaut. A lower "ß" stays "ß" because there is no upper "ß"

Example 

 SELECT 'Dies Ist Ein Test Äh' AS ISCORRECT, F_PROPERCASE('dies ist ein test äh') FROM RDB$DATABASE;

Expected results: 

 ISCORRECT                  F_PROPERCASE
 ========================== ==================================================================
 Dies Ist Ein Test Äh       Dies Ist Ein Test Äh

Example 

 SELECT NULL AS ISCORRECT, F_PROPERCASE(NULL) FROM RDB$DATABASE;

Expected results: 

 ISCORRECT PROPERCASE
 ========= ===============================================================================
 <null>    <null>

back to top of page
<< F_UPPER F_ANSIUPPERCASE U_UPPER | IBExpert UDF Functions | F_CHARACTER U_CHR >>