Does anyone know how to search and replace a string within a BLOB field? I have a firebird 2.1 Databse and I am trying to search for a word and replace it with another word when it is found. I have tried downloading some applications to view/edit the BLOB fields but havent had much luck yet. Is there any app someone would recommend to do this? How would I write the query to replace the string? Any help would be appreciated.