move last three characters of column to a new column I have a column ( cases ) that contains 14 characters xxxxxxxxxx-xxx
I need to remove the "-" and move the last three characters to column ( subcase ) 

is there a easy way to do this as there are 1000's of entries
Create your new column, then do something like:

UPDATE mytable
SET subcase = RIGHT(cases,3)
   ,cases = LEFT(cases,10)