Converts a string to all upper case characters.
This function returns the same datatype as the passed parameter.
UPPER( character_expression )
Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.
> select upper(name) nme from individuals; NME -------------------------------------------------- MS. MARY LEWIS MRS. ALICE R TOLLIVER MR. SIDNEY K TOLLIVER MRS. JENNIFER J HOPKINS MR. CHARLIE HOPKINS MS. KIMBERLY BLUE KATHLEEN TUCKER
See also: