SQL Server LOWER() Function: Convert String to Lower Case
In SQL Server, the
LOWER() function converts the specified string into lower case.
character_expression: A string that has to be converted to lowercase. It can be of a type character string or binary data. It can be a constant, variable, or table column. It must be of the data type that is implicitly convertible to varchar data type.
Returns the lower cased string of type varchar or nvarchar.
In the following example, strings ‘Hello World’ and ‘ABCDEF’ are converted to lower case.
SELECT LOWER('Hello World') AS Lowercase, LOWER('ABCDEF') AS LowerCaseAlphabets
In the following example,
LastName columns from the Employee table are converted to lowercase.
SELECT LOWER(FirstName) AS FirstName, LOWER(LastName) AS LastName FROM Employee