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






  1. SQL Server / T-SQL
  2. String Functions
  3. UPPER

UPPER: Translates all characters within the string to upper case


1> -- UPPER: Translates all characters within the string to upper case.
2>
3> DECLARE @UPPER_STRING char(100)
4> SET @UPPER_STRING = "www.Java2s.com"
5>
6> SELECT UPPER(@UPPER_STRING)
7> GO

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

(1 rows affected)
1>








Related examples in the same category

1.UPPER: change string to upper case
2.Combine Lower() Upper() and substring() function to capital the first letter in a word