lower-transact-sql.md

title	LOWER (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/13/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	LOWER LOWER_TSQL
dev_langs	TSQL
helpviewer_keywords	characters [SQL Server], lowercase LOWER function uppercase characters [SQL Server] characters [SQL Server], uppercase lowercase characters converting uppercase to lowercase characters
ms.assetid	1783352b-6852-4658-9d94-51963c59b9bf
caps.latest.revision	37
author	BYHAM
ms.author	rickbyh
manager	jhubbard

LOWER (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all_md]

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

Transact-SQL Syntax Conventions

Syntax

-- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse  
  
LOWER ( character_expression )  

Arguments

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.

Return Types

varchar or nvarchar

Examples

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 [!INCLUDEssSampleDBnormal] 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  

[!INCLUDEssResult]

Lower Upper LowerUpper

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

minipump MINIPUMP minipump

taillights - battery TAILLIGHTS - BATTERY taillights - battery

(2 row(s) affected)

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

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.

-- Uses AdventureWorks  
  
SELECT LOWER(SUBSTRING(EnglishProductName, 1, 20)) AS Lower,   
       UPPER(SUBSTRING(EnglishProductName, 1, 20)) AS Upper,   
       LOWER(UPPER(SUBSTRING(EnglishProductName, 1, 20))) As LowerUpper  
FROM dbo.DimProduct  
WHERE ListPrice between 11.00 and 20.00;  
  

[!INCLUDEssResult]

Lower Upper LowerUpper

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

minipump MINIPUMP minipump

taillights – battery TAILLIGHTS – BATTERY taillights - battery

See Also

Data Types (Transact-SQL)
String Functions (Transact-SQL)