Received: from fisherrose-bh.frco.com (fisherrose-bh.frco.com [206.242.150.66]) by hub.org (8.9.2/8.9.1) with ESMTP id RAA73023 for ; Wed, 10 Mar 1999 17:02:47 -0500 (EST) (envelope-from danla@micromotion.com) Received: (from uucp@localhost) by fisherrose-bh.frco.com (8.8.8/8.6.11) id QAA28866 for ; Wed, 10 Mar 1999 16:02:46 -0600 (CST) Received: from smtpmail.frco.com(155.177.72.21) by fisherrose-bh.frco.com via smap (4.1) id xmapb8264; Wed, 10 Mar 99 16:02:08 -0600 Received: from icarus.mmi.frco.com ([155.177.99.122]) by smtpmail.frco.com (Post.Office MTA v3.1.2 release (PO205-101c) ID# 0-0U10L2S100) with ESMTP id AAA118 for ; Wed, 10 Mar 1999 15:45:19 -0600 Received: from micromotion.com (localhost [127.0.0.1]) by icarus.mmi.frco.com with ESMTP (8.7.1/8.7.1) id OAA19468 for ; Wed, 10 Mar 1999 14:58:01 -0700 (MST) Sender: danla@icarus.mmi.frco.com Message-ID: <36E6EAE8.4F163DA7@micromotion.com> Date: Wed, 10 Mar 1999 14:58:01 -0700 From: Dan Lauterbach X-Mailer: Mozilla 4.5 [en] (X11; U; HP-UX B.10.20 9000/735) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How match percent sign in SELECT using LIKE? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How do I match '%' in a SELECT query using LIKE predicate? For example, to query for DocNo's containing string 'EW%': SELECT * FROM XXXX WHERE DocNo LIKE '%EW%%'; PostgreSQL wants to treat the '%' in 'EW%' as a wildcard. I've tried escaping the '%' using '\%', '%%'. The SQL-92 standard provides for this using the ESCAPE keyword: SELECT * FROM XXXX WHERE DocNo LIKE '%EW#%%' ESCAPE '#'; However, PostgreSQL doesn't appear to support the ESCAPE keyword. Any suggestions would be greatly appreciated. I'm using PostgreSQL v6.2.1. Thanks, Dan Lauterbach