Received: from priv-edtnes10-hme0.telusplanet.net (mtaout.telus.net [199.185.220.235]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6SICdf63205 for ; Sat, 28 Jul 2001 14:12:39 -0400 (EDT) (envelope-from roy@silicontao.com) Received: from UtopiaPlanitia ([142.59.72.239]) by priv-edtnes10-hme0.telusplanet.net (InterMail vM.4.01.03.10 201-229-121-110) with SMTP id <20010728181237.HAQM838.priv-edtnes10-hme0.telusplanet.net@UtopiaPlanitia> for ; Sat, 28 Jul 2001 12:12:37 -0600 Content-Type: text/plain; charset="iso-8859-1" From: Roy Souther Reply-To: Roy Souther Organization: Silicon Tao Technology Systems To: pgsql-sql@postgresql.org Subject: Who do I make _ not a wildcard? Date: Sat, 28 Jul 2001 12:12:51 -0600 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01072812125100.02455@UtopiaPlanitia> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/371 X-Sequence-Number: 4185 In PG the _ is a wildcard that means any singal char. I need to do a search for the actual _ char and not get back thousands of wrong matches. Is there and escape char that I could use? This needs to work with PG 7.0.3 & 7.1.2. TIA -- Roy Souther 01100010 10101110 11000110 11010110 00000100 10110010 10010110 11000110 01001110 11110110 11001110 00010110 10010110 00101110 10000100 10000100