Or, if you are not confident with directly modifying the system tables, you could do the following

alter table mytable add col3 char(1) NULL, col4_copy char(1) NULL

Update mytable set col4_copy =...

When you look at the @@Error variable, it it is reset to 0 afterwards.

So, to return it as a return from the stored procedure you would need to extract...