LOWER (Transact-SQL)

最新推荐文章于 2022-03-25 08:08:13 发布

原创最新推荐文章于 2022-03-25 08:08:13 发布 · 528 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#character #function #types #string

SQL 专栏收录该内容

5 篇文章

订阅专栏

本文介绍了 Transact-SQL 中的 LOWER 函数，该函数用于将字符数据从大写转换为小写。通过示例展示了如何使用 LOWER 函数，并结合其他字符串处理函数进行数据操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

Topic link icon Transact-SQL Syntax Conventions

Copy

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.

Copy

USE AdventureWorks2008R2;

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)