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