Search and Replace BLOB Field Firebird

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.
rknealAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gskoczylasSenior Software DeveloperCommented:
Use FreeAdHocUDF.
0
gskoczylasSenior Software DeveloperCommented:
Sorry, accidentally  sent an unfinished lists.

Use FreeAdHocUDF library (http://freeadhocudf.org). Use either the f_BlobReplaceString or the u_BlobReplaceString function.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rknealAuthor Commented:
Ok, I found a utility that came installed on my server that allows me to view the BLOB data in Firebird.  It has a query writer that allows me to write a query similar to SQL.  Can anyone tell me the syntax of the query to search a BLOB field for the string Processnetreg?

Something like this: SELECT * FROM GLOBALCONFIG WHERE blobData LIKE '%PROCESSNETREG%'
 
I tried that but it doesnt seem to work.  Since the field isn't actually a text field can I search this way?
0
tty2Commented:
Construction "where ... like ..." works, in any case with Blob sub_type 0.
What sub_type has blob in your table? Check DDL.
More details how to work with blob fields - http://www.ibphoenix.com/main.nfs?page=ibp_blobs.
0
rknealAuthor Commented:
Works but was in a different language
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.