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