Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Changing Strings to Sentence Case

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>