Export (0) Print
Expand All
Expand Minimize

LOWER (Transact-SQL)

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

Topic link iconTransact-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.

USE AdventureWorks;
GO
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)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft