hello ib-support readers!

i have some code written in C that uses the embedded SQL / C api.

i've run into an issue: 'like' statements don't find a match if the
pattern ('%<my-tag>%searchstring%</my-tag>%') is spread over multiple
blob segments.

a couple of questions:

1. is there a work around for this?

2. is there a work around for this that doesn't require a UDF or
stored procedure code.

3. what about "stream" blobs? is there such a thing available for use
with C?

thanks in advance,

- avi