Adding column between two other columns in SQL server

Question

Can you add a column to a table inserting it in between two existing columns in SQL Server without dropping and re-creating the table?

Answer 1

The simple answer is no. Is there a reason why column order is important to you?