您現(xiàn)在的位置： > 技術(shù)沙龍 > 數(shù)據(jù)庫 > SQL Server > Transact-SQL 參考 > LOWER
- 相關(guān)軟件
>LOWER 創(chuàng)建者：webmaster 更新時間：2006-02-16 15:51將大寫字符數(shù)據(jù)轉(zhuǎn)換為小寫字符數(shù)據(jù)后返回字符表達(dá)式。
語法
LOWER ( character_expression )
參數(shù)
character_expression
是字符或二進(jìn)制數(shù)據(jù)表達(dá)式。character_expression 可以是常量、變量或列。character_expression 必須是可以隱性轉(zhuǎn)換為 varchar 的數(shù)據(jù)類型。否則，使用 CAST 顯式轉(zhuǎn)換 character_expression。
返回類型
varchar
示例
下例在選擇價格位于 $11 和 $20 間的書名時，使用 LOWER 函數(shù)、UPPER 函數(shù)并把 UPPER 函數(shù)嵌套在 LOWER 函數(shù)內(nèi)。
USE pubs
GO
SELECT LOWER(SUBSTRING(title, 1, 20)) AS Lower,
UPPER(SUBSTRING(title, 1, 20)) AS Upper,
LOWER(UPPER(SUBSTRING(title, 1, 20))) As LowerUpper
FROM titles
WHERE price between 11.00 and 20.00
GO下面是結(jié)果集：
Lower Upper LowerUpper
相關(guān)文章
-------------------- -------------------- --------------------
the busy executive's THE BUSY EXECUTIVE'S the busy executive's
cooking with compute COOKING WITH COMPUTE cooking with compute
straight talk about STRAIGHT TALK ABOUT straight talk about
silicon valley gastr SILICON VALLEY GASTR silicon valley gastr
secrets of silicon v SECRETS OF SILICON V secrets of silicon v
prolonged data depri PROLONGED DATA DEPRI prolonged data depri
fifty years in bucki FIFTY YEARS IN BUCKI fifty years in bucki
sushi, anyone? SUSHI, ANYONE? sushi, anyone?
(8 row(s) affected)
本頁查看次數(shù):