Querying Blobs

[Tulsa]

I am trying to search a column of blobs for a matching string. It seems as
though this is impossible and blobs cannot be used in wildcard searches and
casting does nothing. I was just wondering if anyone knew how to do this
before I gave up. Unfornately my db type is informix, but I would appreciate
all db type specific suggestions. Thanks for help.
<cfquery name="test" datasource="e4500">
select dm_notes
FROM dm_notes
WHERE dm_notes MATCHES '*Pulled By*'
</cfquery>

[Dan Bracuk]

I don't know anything about blobs, but, what would happen if you changed your
where clause to:

where lcase(dm_notes) like '%pulled by%'

The name of the lower case function might be somethint other than lcase.

[Kronin555]

Tulsa,

I don't know Informix, so your best bet would be to ask on an informix forum.

Is there any way in Informix to make a full text index on the blob data?

Sorry I can't help more, but I stay away from clobs and blobs as much as
possible because of the simple things that they make very difficult.