Re: How to search for a string in a TEXT field

From: vivek.chaudhary@st.com > You can. Here is the example: > > SELECT REPLACE("Mighzxy zxime","zx","t") AS your_output FROM ABC; I don't have a 7.3x instance handy right now to test this, but the manual says anything that can be cast to a CHAR, and I don't think you can cast a TEXT to a CHAR, can you? I mean, what if your TEXT were bigger than 32K, for example? Furthermore, the manual clearly says: You also cannot use TEXT items in the following ways: n With aggregate functions n With the IN clause n With the MATCHES or LIKE clauses ****** (This is generally how I search using a string :-) n With the GROUP BY clause n With the ORDER BY clause > your_output > ----------- > > Mighty time > > Example taken from Informix manual. > > Vivek >______________________________ Reply Separator >_________________________________ >Author: obnoxio (obnoxio@hotmail.com) at internet > >From: "Emmanuel Weyers" <Emmanuel.Weyers@orange.be> >> >>How to search for a string in a TEXT field: >>Informix Dynamic Server Version 7.31.UC2A > >Well, I don't think you can. You'd have to upgrade to 9.x and get either >the >Verity Text Search or the Excalibur Text DataBlades (or roll your own...) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com