Received: from modi.deman.com ([204.201.133.6]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA31564 for ; Tue, 15 Feb 2000 12:05:59 -0500 (EST) (envelope-from carl@planetcpub.com) Received: from jupiter (wks5.planetcpub.com [204.200.43.254]) by modi.deman.com (8.9.3/8.9.3) with SMTP id JAA19819 for ; Tue, 15 Feb 2000 09:05:49 -0800 (PST) Reply-To: From: "Carl Flansbaum" To: Subject: Techniques for quickly finding words in a phrase... Date: Tue, 15 Feb 2000 09:08:46 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Hello, Ok, can anyone help with the following... I'm also looking to write a SQL query to find a specific string in a target of words. the field contains values like 1234 2456 1234a etc. The problem is that the string must be exact, so while using WHERE foo ~ '1234'; or WHERE foo LIKE '1234'; or WHERE foo ~* '[[:<:]]1234'; will work, it also brings up results with the 1234a value in the field. I've tried a wide variety of pattern matching with no luck. any advice? thanks carl