sql query find a value and delete a piece of a value in column code example

Example: sql delete all values in a column

UPDATE TableName SET ColumnName = NULL