Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2C3834766FF for ; Thu, 29 Aug 2002 15:20:47 -0400 (EDT) Received: from hotmail.com (f193.law9.hotmail.com [64.4.9.193]) by postgresql.org (Postfix) with ESMTP id 91A64476227 for ; Thu, 29 Aug 2002 15:20:46 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 29 Aug 2002 12:20:47 -0700 Received: from 200.84.69.10 by lw9fd.law9.hotmail.msn.com with HTTP; Thu, 29 Aug 2002 19:20:46 GMT X-Originating-IP: [200.84.69.10] From: "Zenith Vivas" To: pgsql-sql@postgresql.org Subject: How to Select with more than one AND in a Where SQL Clause? Date: Thu, 29 Aug 2002 19:20:46 +0000 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 29 Aug 2002 19:20:47.0222 (UTC) FILETIME=[2D833160:01C24F91] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/422 X-Sequence-Number: 9268 Dear friends, I need a SQL sentence like this: Qry = "Select * from Table Where A1 Like '%' AND A2 Like '%' AND A3 Like '%' AND A4 Like '%' AND A5 Like '%'" But in spite of I need a SQL sentence with four (04) AND's in its Where clause, my SQL compiler only allow me using one AND. So How can I solve such a problem. Many thanks in advance! Zenith Vivas _________________________________________________________________ Charle con sus amigos online usando MSN Messenger: http://messenger.msn.com