How can I get different Match Patterns in data stored in BLOB (Text) Variable in INFORMIX Database ?

Hi All, How can I get different Match Patterns in data stored in BLOB(Text)Variable in INFORMIX Database ? For Example : Suppose in my Database named "Employee" in INFORMIX ,there is a BLOB Text Field named "Address".I want to write a SQL Query to search different Match Patterns for data stored in that BLOB Address field. When I use "Select" statement using "like" with search patterns,it produces error with "error no -615 ". Can we have Alternate Solutions also ? Regards, Durgesh Sharma

On Tue, 26 Oct 2004 08:07:03 -0400, Durgesh Sharma wrote: > Hi All, > > How can I get different Match Patterns in data stored in BLOB(Text)Variable > in INFORMIX Database ? > > For Example : > Suppose in my Database named "Employee" in INFORMIX ,there is a BLOB Text > Field named "Address".I want to write a SQL Query to search different Match > Patterns for data stored in that BLOB Address field. When I use "Select" > statement using "like" with search patterns,it produces error with "error no > -615 ". > > Can we have Alternate Solutions also ? 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