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

Posted in 2004

Paul Watson — Thu, 28 Oct 2004 20:36:40 +0100 — source: Usenet: comp.databases.informix

If you want to search text Blobs then the easiest wayis to use the text datablade 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 ? > > Regards, > Durgesh Sharma -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #