How to delete all data of a specific column

[CandyMe]

sql server 2005 How do I delete all data of a specific column Thank you.

[rittjc]

Hi Candy, Try using an update query: "UPDATE targetTable SET targetTable.targetColumn = NULL" Where targetTable is the table that contains the column, targetColumn which is the column you want to delete the data from. Jim

[CandyMe]

Oh yah! Thank you so much. :-O:-> X|