F_LOWER
<< F_SUCC U_SUCC | IBExpert UDF Functions | F_UPPER F_ANSIUPPERCASE U_UPPER >>
F_LOWER
substitutable with LOWER
- function from adhoc
F_ANSILOWERCASE
- compatibility to FreeUDFLib AvERP, GrUDF
U_LOWER
- 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, F_LOWER('Beautiful DAY') FROM RDB$DATABASE;
Expected results:
ISCORRECT F_LOWER ============= =============================================================================== beautiful day beautiful day
Example
SELECT NULL AS ISCORRECT, F_LOWER(NULL) FROM RDB$DATABASE;
Expected results:
ISCORRECT F_LOWER ============= =============================================================================== <null> <null>
back to top of page
<< F_SUCC U_SUCC | IBExpert UDF Functions | F_UPPER F_ANSIUPPERCASE U_UPPER >>