UPPER Translates all characters within the string to upper case. : UPPER « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. UPPER
3> DECLARE @UPPER_STRING char(100)
4> SET @UPPER_STRING = "www.java2s.com java2s"
5>
6> SELECT UPPER(@UPPER_STRING)
7> GO


------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------
WWW.JAVA2S.COM JAVA2S


(1 rows affected)








12.24.UPPER
12.24.1.UPPER Translates all characters within the string to upper case.
12.24.2.The LOWER() and UPPER() Functions
12.24.3.select UPPER('ca')
12.24.4.Changing Character Values to Upper