精品国产亚洲一区二区三区,男女作爱在线观看免费网站,欧美的又大又长做禁片A片,97国产精品人妻无码久久久

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