I am using SQL Server 2008.
How would you write a SQL UPDATE statement to populate the
BRANCH field, a 3 character field. The source would be the 4th position (up to 3 characters in length) of the COSTCENTER field.
SET BRANCH = SUBSTRING(COSTCENTER,4,LEN(COSTCENTER)-3)