How to update varbinary with null value in image field in SQL Server 2008?

Question

I uploaded the image and saved it in the image field in the database, this image is saved as 0xFFD8FFE. When I try to update the above with zero as getting an exception called:

Image and varbinary (max) data types are incompatible in the equality operator

I want to change the above value to zero.

Answer 1

Just set it to null with the update statement:

UPDATE dbo.MyTable
  SET MyFieldName = NULL
  WHERE MyPrimaryKey = 12345

Answer 2

organization update set logo = null where logo as 0xFFD8FFE00010