UPPER(LEFT([State], 1)) + LOWER(SUBSTRING([State],2,LEN([State])))

Is one way of doing this, though it would be better to update your insert Stored Procs than use a trigger.