Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e7FJ3Qn28169 for ; Tue, 15 Aug 2000 15:03:26 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id MAA52806 for ; Tue, 15 Aug 2000 12:03:20 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <399993CA.D52F25D4@ipinc.com> Date: Tue, 15 Aug 2000 12:02:34 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: % escape Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/120 Hi,there, Is anybody know how I can escape % or ' (my column contains % or ' ) in my text field. select mystring from textbook where mystring like ..... -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com