1> -- LOWER: Translates all characters within the string to lower case.
2>
3> DECLARE @LOWER_STRING CHAR(100)
4> SET @LOWER_STRING = "www.rntsoft.com"
5>
6> SELECT LOWER(@LOWER_STRING)
7> GO
---------------------------------------------------------------------------
www.rntsoft.com
(1 rows affected)
1>