T-SQL Tutorial

T-SQL LOWER String Function


LOWER function is an string function and return a character expression after converting uppercase character data to lowercase.

LOWER Syntax:

LOWER ( string_expression );

LOWER Example:

DECLARE @mystring varchar(250);
SET @mystring = 'Convert TRANSACT SQL LOWER Function';
SELECT LOWER(@mystring);
GO

Result
convert transact sql lower function

See also: T-SQL Functions -> UPPER -> Concat -> Left -> Len -> Lower -> Ltrim