是否全大寫

朋友的需求,在此簡單做個範例
CREATE FUNCTION fnIsCapitalization ( @c varchar(10))
RETURNS bit
AS
BEGIN
 DECLARE @Result BIT
 IF CONVERT(varbinary(10),@c)=CONVERT(varbinary(10),upper(@c))
  SET @Result=1
 ELSE
  SET @Result=0
 RETURN @Result
END
GO
–測試
SELECT dbo.fnIsCapitalization(‘abc’),dbo.fnIsCapitalization(‘ABc’),dbo.fnIsCapitalization(‘ABC’)
–結果
—– —– —–
0     0     1

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: