Subject Case-insensitive 'containing' on a BLOB - perhaps UDF?
Author Jonathan Hull
Hi all,
I would like to do a case insensitive string search on a binary blob
(eg a stored Word Doc file), preferrably using standard SQL.

My research indicates this is not possible in IB6, FB1 or FB1.5.

Does anyone have a strategy that works in FB1.5? Perhaps a UDF
function? The only other approach that I can imagine (after a strong
coffee) would be to tokenise the text on the way in so each BLOB has a
corresponding text field containing keywords, but this seems a pretty
high overhead.

All comments will be very welcome.

Also, if your listening Helen, I can't wait for the word on your (even
bigger) bible to become available.

Cheers from New Zealand