Microsoft SQL Server Lower


Example

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

Parameters:

  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'