select (column1+column2) AS column1, table1.* from table1
both column1 and column2 are columns in table1. Is there anyway that when I run the query I can get only the new column1 is shown and the old one is ignored?
My current option is spell out every column in the table that I actually do want to show up
Edit: This is with SQL 2008 R2, but I'd be interested if other SQL versions have a solution as well