UPDATE category SET chrCat_Full_Name=UPPER(LEFT(chrCat_Full_Name,1)) +LOWER(RIGHT(chrCat_Full_Name,DATALENGTH(chrCat_Full_Name)+1))