Received: from ns.eurobase.net (root@ns.eurobase.net [207.153.121.2]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA13831 for ; Thu, 2 Dec 1999 15:58:30 -0500 (EST) (envelope-from tom@eurobase.net) Received: from otto (otto.eurobase.net [207.153.121.21]) by ns.eurobase.net (8.9.3/8.9.3) with SMTP id PAA26654 for ; Thu, 2 Dec 1999 15:58:31 -0500 Reply-To: From: "Tom Techoueyres" To: Subject: A search SQL query Date: Thu, 2 Dec 1999 15:51:51 -0500 Message-ID: <002f01bf3d07$0f27df80$157999cf@eurobase.net> 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 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal Hi, I am using a cursor search using sql queries to get information from a database that has 5 fields. The search is done on one of the fields which are "electronic components parts". My users usually type in the all part number they are looking for in the form. Here is the situation I have, lets say that a user is looking for part 'LM741CN-SGS', I have the follwoing queries: - select * from inventory where partno like 'LM741CN-SGS' (exact search) - select * from inventory where partno like 'LM741CN-SGS%' (partial search) - select * from inventory where partno like '%LM741CN-SGS%' (extended search) Now I need to create a query that when the user looks for 'LM741CNSGS', the result comes back with all rows with 'LM741CN-SGS' and and all rows with 'LM741CNSGS'. What would the suggested sql query to provide that type of result? I would appreciate any feedback. Thank you, Tom Techoueyres tom@eurobase.net