Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

UPPER Translates all characters within the string to upper case

3> DECLARE @UPPER_STRING  char(100) 4> SET @UPPER_STRING = "www.rntsoft.com rntsoft" 5> 6> SELECT UPPER(@UPPER_STRING) 7> GO ------------------------------------------------------------------------------------------------------------------------ -------------------------------------------------------------------------------- WWW.RNTSOFT.COM RNTSOFT (1 rows affected)