Although your code works fine, it wouldn't be my first choice as if the OP could change the schema, normalizing the data would be a better option. Also your code has about the same flexibility as the sample below.

😎

SELECT

P.Name

,P.ProjectName

,CONVERT(INT,P.[20140728]) + CONVERT(INT,P.[20140804])

FROM #Planner P