UPPER#
Returns a character expression with lowercase character data converted to uppercase.
Syntax#
UPPER ( character_expression )
Arguments#
character_expression
Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data.
character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.
Return types#
varchar or nvarchar
Examples#
SELECT UPPER('upper');