Changing Strings to Sentence Case : LOWER « String Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. String Functions
  3. LOWER
5>
6> SELECT UPPER(SUBSTRING("this Is a tEst.",1,1)) +
7>          LOWER(SUBSTRING("this Is a tEst.",2,20))
8> GO

----------------
This is a test.

(1 rows affected)
1>








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