亚洲av色香蕉一区二区三区,十四以下岁毛片带血a级,亚洲 校园 欧美 国产 另类,亚洲av日韩av一区谷露,色欲av无码一区二区三区

將大寫字符數(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

示例

下例在選擇價(jià)格位于 $11 和 $20 間的書名時(shí)，使用 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           
--------------------    --------------------    -------------------- 
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)