Character Case Functions
Description
Functions to test and manipulate the case of characters.
- Name
- Description
- CASE_PRESERVE Function
Returns a string + the case information.
- CASE_RESTORE Function
Restore a string from its case information.
- F_UPPER Function
Capitalizes the first letter of a string.
- LOWER Function
Converts a character string to lowercase.
- LT Function
Converts a string to lower case and trims trailing/leading blanks.
- NF_LOWER Function
Returns a string that is lowercased except for the first letter.
- NW_LOWER Function
Returns a string that is lowercased except for the first letter of each word.
- UPPER Function
Converts a character string to uppercase.
- UT Function
Returns the uppercase trimmed version of the string supplied.
- W_UPPER Function
Capitalizes the first character of each word in a character string.
- WUT Function
Capitalizes the first letter of each word in a string and removes all leading and trailing whitespace.
Related Functions
LOWER() - Converts an Input_String to lowercase.
UPPER() - Converts an Input_String to uppercase.
See Also