TechNet
Export (0) Print
Expand All

LOWER (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

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

Topic link icon Transact-SQL Syntax Conventions

-- Syntax for SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse  
  
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)

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 is the result set.

Lower Upper LowerUpper

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

minipump MINIPUMP minipump

taillights – battery TAILLIGHTS – BATTERY taillights - battery

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

Community Additions

ADD
Show:
© 2016 Microsoft