Ed, yes, I was seriously confused about those characters, didn't realize they were supposed to be the less than/greater than symbols.

That code is now running without error, but the problem...

t1.Company,

t2.CustID

(CASE

WHEN custid like '%abc%' and company = 'abc'

then null

ELSE custid

END),

from Dtl1 t1

left outer join Customer t2

on t1.Company = t2.Company

and t1.CustNum = t2.CustNum

join Reason t3

on t1.Company = t3.Company

and t1.ReasonCode= t3.ReasonCode

join Head1...

With those new characters, I get the following error message without displaying the change:

"An expression of non-boolean type specified in a context where a condition is expected."

Thanks Phil, I'm not getting any errors, however my returndate restriction is no longer working,

(where t4.ReturnDate >= DATEADD(yy,-2,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)))

it is pulling all results, instead of those just going back two years.

Current...