RTFM Read the Guide to SQL Reference, section on Data Types, Built-In, Simple
Large Objects.  It says, to paraphrase, simple large objects cannot be used in
LIKE, MATCHES, IN, GROUP BY, or ORDER BY clauses, aggregate functions, or
string or boolean expressions (except to test for IS NULL or IS NOT NULL).

The only work around is to parse the BLOB before loading it and create a set
of keyword lookup tables to query loading significant words in those tables
and search there instead.  If you have IDS 9.xx try writing your own search
UDF in 'C' or Java or use Smart Blobs or even better one of the Full Text
Search Data Blades.

Art S. Kagel