LOWER Translates all characters within the string to lower case. : LOWER « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. LOWER
3>
4> DECLARE @LOWER_STRING CHAR(100)
5> SET @LOWER_STRING = "www.java2s.com"
6>
7> SELECT LOWER(@LOWER_STRING)
8> GO


------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------
www.java2s.com


(1 rows affected)








12.8.LOWER
12.8.1.LOWER Translates all characters within the string to lower case.
12.8.2.Changing Strings to Sentence Case
12.8.3.select LOWER('SQL Server')
12.8.4.Changing Character Values to Lower