Received: from mailsvr1.gte-es.com (mailsvr1.gte-es.com [207.223.13.199]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA17869 for ; Thu, 20 Aug 1998 09:53:57 -0400 (EDT) Received: from gte-es.com ([207.223.13.194]) by mailsvr1.gte-es.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2232.9) id R18Z78ML; Thu, 20 Aug 1998 09:53:32 -0400 Sender: root Message-ID: <35DC29A3.92801C6E@gte-es.com> Date: Thu, 20 Aug 1998 13:50:28 +0000 From: Steve Maring Reply-To: smaring@gte-es.com Organization: GTE Enterprise Solutions X-Mailer: Mozilla 4.5b1 [en] (X11; I; Linux 2.0.34 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: problem with LIKE predicate and wildcards Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The only way I have been able to get the LIKE predicate to work at all is like this: SELECT * FROM profiles WHERE lastname LIKE 'Marin%'; returns rows with lastname starting with 'Marin' I cannot seem to say: LIKE '%aring' LIKE 'Ma%ing' LIKE '_aring' Specifically I need to search for rows like this: SELECT id FROM profiles WHERE id LIKE '_____001'; should return: TAMP-001 DALL-001 VANC-001 Can someone PLEASE help me. I'm desparate! Thanks. -Steve Maring smaring@gte-es.com Tampa, FL USA