Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

LOWER (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database, Azure SQL Data Warehouse Public Preview.

Topic link icon Transact-SQL Syntax Conventions

LOWER ( character_expression )

character_expression

Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.

varchar or nvarchar

The following example uses the LOWER function, the UPPER function, and nests the UPPER function inside the LOWER function in selecting product names that have prices between $11 and $20. This example uses the AdventureWorks2012 database.

SELECT LOWER(SUBSTRING(Name, 1, 20)) AS Lower, 
   UPPER(SUBSTRING(Name, 1, 20)) AS Upper, 
   LOWER(UPPER(SUBSTRING(Name, 1, 20))) As LowerUpper
FROM Production.Product
WHERE ListPrice between 11.00 and 20.00;
GO

Here is the result set.

Lower Upper LowerUpper

--------------------- --------------------- --------------------

minipump MINIPUMP minipump

taillights - battery TAILLIGHTS - BATTERY taillights - battery

(2 row(s) affected)

Community Additions

ADD
Show:
© 2015 Microsoft