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 QAA61813 for ; Wed, 10 Mar 1999 16:02:22 -0500 (EST) (envelope-from danla@micromotion.com) Received: (from uucp@localhost) by fisherrose-bh.frco.com (8.8.8/8.6.11) id PAA23218 for ; Wed, 10 Mar 1999 15:02:18 -0600 (CST) Received: from smtpmail.frco.com(155.177.72.21) by fisherrose-bh.frco.com via smap (4.1) id xmasc1841; Wed, 10 Mar 99 15:01:10 -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 AAA240 for ; Wed, 10 Mar 1999 14:47:39 -0600 Received: from micromotion.com (localhost [127.0.0.1]) by icarus.mmi.frco.com with ESMTP (8.7.1/8.7.1) id OAA19437 for ; Wed, 10 Mar 1999 14:00:19 -0700 (MST) Sender: danla@icarus.mmi.frco.com Message-ID: <36E6DD61.EFC1B2F4@micromotion.com> Date: Wed, 10 Mar 1999 14:00:18 -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