Thanks for the instant response! Works like a charm! :)))
-----Original Message----- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 10, 2001 7:34 PM To: SQL Subject: Re: Mayday !! Use paranthesis like: AND (UPPER(b.FIRST_NAME) like '%ASHWANI%' OR UPPER(b.LAST_NAME) like '%ASHWANI%' ) HTH, Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >>> http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "Stacy Young" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Wednesday, October 10, 2001 7:30 PM Subject: Mayday !! > I have a query that needs to search two columns to see if a particular > value exists. Trick is the value may exist in EITHER column...and it > seems if I use OR it disregards my other WHERE clauses and I get > 1000's upon 1000's of records !!... > > example: > > AND UPPER(b.FIRST_NAME) like '%BOB%' > OR UPPER(b.LAST_NAME) like '%BOB%' > > (part of this larger query) > > SELECT distinct a.ACCOUNT_ID, > a.SEQ, > a.DATE, > a.STAT_CODE, > a.AMT, > a.MERCHANT_XAID, > b.PROCIB_BRAN_CODE, > b.CARD_ENDING, > b.AUTH_CODE, > b.AVS_INFO, > b.FIRST_NAME, > b.LAST_NAME, > c.ACCOUNT_ID, > c.ACCOUNT_NAME, > rownum rnum > FROM TABLE1 a,TABLE2 b,TABLE3 c > WHERE DATE >= TO_DATE('10092001 00:00:00','MMDDYYYY HH24:MI:SS') > AND DATE <= TO_DATE('10102001 23:59:59','MMDDYYYY > HH24:MI:SS') > AND ACCOUNT_ID='16161616' > AND STAT_CODE='B' > > AND UPPER(b.FIRST_NAME) like '%ASHWANI%' > OR UPPER(b.LAST_NAME) like '%ASHWANI%' > > AND a.SEQ=b.SEQ > AND a.ACCOUNT_ID=b.ACCOUNT_ID > AND a.ACCOUNT_ID=c.ACCOUNT_ID > > Any ideas on how to approach this? > > Thanks very much! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
