sql server 2005 - delete column in sql but previous data can not be deleted -

sql server 2005 - delete column in sql but previous data can not be deleted -

i want delete column in sql info in deleted column should not deleted should remains previous. when execute table should show column name except deleted column , when search info table should show deleted column info , new column data.. there alternative in sql these kind of situation.. in advance...

i think talking soft deletion or logical deletion. in such case best thought have 1 boolean column is_deleted or that. whenever delete record mark is_deleted=true , default is_deleted false

sql sql-server-2005