Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Using DATALENGTH to determine length of a string value

6>      SELECT UPPER(SUBSTRING("this Is a tEst.",1,1)) + 7>            LOWER(SUBSTRING("this Is a tEst.",2, 8>               (DATALENGTH("this Is a tEst.")-1))) 9> 10> GO --------------- This is a test. (1 rows affected)