TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

LOWER (SQL Server Compact)

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


LOWER ( character_expression ) 

character_expression

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

nvarchar or ntext

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
Show:
© 2016 Microsoft