John Mitchell-245523 (9/27/2016)

---

If you always have a space in the middle of your postcode, and you want to match everything to the left of the space, change your join predicate to this:

LEFT(N.[Office Post Code],CHARINDEX(' ',N.[Office Post Code])) = LEFT(L.[Office Post Code],CHARINDEX(' ',L.[Office Post Code]))

John