Microsoft SQL Server Lower


Returns a character expression (varchar or nvarchar) after converting all uppercase characters to lowercase.


  1. Character expression. Any expression of character or binary data that can be implicitly converted to varchar.
SELECT LOWER('This IS my STRING') -- Returns 'this is my string'

DECLARE @String nchar(17) = N'This IS my STRING';
SELECT LOWER(@String) -- Returns 'this is my string'