Editing multiple BLOBs at once

[bmacbmac]

Hello. Forgive me, I'm not too familiar with BLOB data.

I have a database with about 2000 rows of BLOB records which contains HTML data for each record. I have to edit data in some of my records. I can edit the data tables with UPDATE, but unsure of how I can edit the BLOB data.

I have a utility where I can open each blob one at a time and do a find/replace for my data. One at a time will take forever though!

Does anyone know of a more efficient way to change these BLOB entries or know of a utility that might help me?

Thanks!

 

[RiverGuy]

If you can change your schema, and are using SQL 2005 +, I would recommend to use a VARCHAR(MAX) column instead (assuming your HTML data is all character data). It will make life much easier for you in the long run.

 

[bmacbmac]

oh... forgot to mention that. Using SQL 2000.