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)