Great I'm also getting results with OPENQUERY.

HOWEVER, i'm interested in knowing why it doesn't work with the 4-part naming...

I had the same Problem, when copying the expression over.

It's the quotation marks.

(FirstName != LkUp_FirstName) || ((ISNULL(MiddleName) ? “Humperdinck” : MiddleName) != (ISNULL(LkUp_MiddleName) ? “Humperdinck“ : LkUp_MiddleName)) || (LastName !=...