LOWER (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
Returns a character expression after converting uppercase character data to lowercase.
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
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;
Here's the result set.
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)