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

Posted in 2000

Emmanuel Weyers — Thu, 10 Aug 2000 12:55:36 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROMtablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A