Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

LOWER Translates all characters within the string to lower case

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)