At 10:18 PM 22/03/2005 +1100, you wrote:

>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"

Hm, I don't think we have all the facts here.

./hb