I have a table with two blob columns and was wondering how I can go
about clearing the blob column's contents?

When trying: UPDATE MyTable SET blob1 = null, blob2 = null

I get the error: Overflow occurred during data type conversion.
conversion error from string "BLOB"

Cheers,
Diego