lower-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
LOWER (Transact-SQL)	LOWER (Transact-SQL)	markingmyname	maghan	03/13/2017	sql	t-sql	reference	LOWER LOWER_TSQL	characters [SQL Server], lowercase LOWER function uppercase characters [SQL Server] characters [SQL Server], uppercase lowercase characters converting uppercase to lowercase characters	TSQL	>= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqldb-mi-current||=fabric

LOWER (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw]

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

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

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.

-- Uses AdventureWorks SELECTLOWER(SUBSTRING(EnglishProductName, 1, 20)) ASLower, UPPER(SUBSTRING(EnglishProductName, 1, 20)) ASUpper, LOWER(UPPER(SUBSTRING(EnglishProductName, 1, 20))) As LowerUpper FROMdbo.DimProductWHERE ListPrice between 11.00and20.00; 

[!INCLUDEssResult]

Lower Upper LowerUpper -------------------- --------------------- -------------------- minipump MINIPUMP minipump taillights - battery TAILLIGHTS - BATTERY taillights - battery 

See Also

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