Delete Certain Columns Only 1

[cwsstins]

I need an SQL statement to delete only 2 out of multiple columns on a table. How can I do this?

I've been experimenting with syntax variations on the DELETE statement, but everything I try deletes all columns for the specified rows.

 

[lewisp]

UPDATE table
SET    col1 = NULL,
       col2 = NULL
WHERE  etc....;