Delete all Data in a column in a table

[Sierras]

Is there an easy way to delete all the data in a specific column on a
single table? I want the rest on the data in that table to stay the
same.

 

[fredg]

Is there an easy way to delete all the data in a specific column on a
single table? I want the rest on the data in that table to stay the
same.

Run an update query:

UPDATE YourTable SET YourTable.FieldName = Null;

 

[Sierras]

That was just too easy. And it actually worked!!

Thanks!!