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

Posted in 2000

vivek.chaudhary@st.com — Wed, 9 Aug 2000 09:08:33 -0700 — source: Informix-list mailing list archive (1991-1998)

You can. Here is the example: SELECT REPLACE("Mighzxy zxime","zx","t") AS your_output FROM ABC; your_output ----------- Mighty time Example taken from Informix manual. Vivek ______________________________ Reply Separator _________________________________ Subject: Re: How to search for a string in a TEXT field Author: obnoxio (obnoxio@hotmail.com) at internet Date: 8/9/00 2:26 AM 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