Returns a character expression after converting uppercase character data to lowercase.

LOWER (character_expression )

Arguments

• character_expression
  An expression of character or binary data type, or a data type that is implicitly convertible to nvarcharor ntext.

nvarchar or ntext

Example

The following example returns, in lowercase, the list of company names in the Customers table.

SELECT [Customer ID], LOWER([Company Name]) AS Expr1, City FROM Customers