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>