RE: Mayday !!

[travis]

Use brackets.  

example:
 
AND (UPPER(b.FIRST_NAME) like '%BOB%' 
OR UPPER(b.LAST_NAME) like '%BOB%' )

Travis Reeder
Chief Software Architect
ThinkVirtual


---- Original Message ----
From: Stacy Young <[EMAIL PROTECTED]>
Sent: 2001-10-10 17:30:35.0
To: SQL <[EMAIL PROTECTED]>
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/sql@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists