F_UPPER
<< F_LOWER F_ANSILOWERCASE U_LOWER | IBExpert UDF Functions | F_PROPERCASE U_PROPERCASE >>
F_UPPER
substitutable with UPPER
- function from adhoc
F_ANSIUPPERCASE
- compatibility to FreeUDFLib AvERP, GrUDF
U_UPPER
- function from adhoc
- Compatible with UTF-8
- Input VARCHAR(32760) String to convert
- Output VARCHAR(32760) String with all characters as lower incl. umlaut
Example
SELECT 'BEAUTIFUL DAY' AS ISCORRECT, UPPER('Beautiful DAY'), F_UPPER('Beautiful DAY') FROM RDB$DATABASE;
Expected results:
ISCORRECT UPPER F_UPPER ============= ============= ========================================================= BEAUTIFUL DAY BEAUTIFUL DAY BEAUTIFUL DAY
Example
SELECT NULL AS ISCORRECT, UPPER(NULL), F_UPPER(NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT UPPER F_UPPER ========= ====== =============================================================================== <null> <null> <null>
back to top of page
<< F_LOWER F_ANSILOWERCASE U_LOWER | IBExpert UDF Functions | F_PROPERCASE U_PROPERCASE >>