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!
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
