I'm sorry... the last statement should read

"select @strVariable as NEW_FIELD"....and the parcer in mgmt studio said it was a good block of code.