String Functions MSSQL Tutorial

3>
4> DECLARE @LOWER_STRING CHAR(100)
5> SET @LOWER_STRING = "www.rntsoft.com"
6>
7> SELECT LOWER(@LOWER_STRING)
8> GO
------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------
www.rntsoft.com
(1 rows affected)