LOWER#

Returns a character expression after converting uppercase character data to lowercase.

Syntax#

LOWER ( character_expression )

Arguments#

character_expression

Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type that is implicitly convertible to varchar.

Return types#

varchar or nvarchar

Example#

SELECT LOWER('lowER');

See Also#