Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys. I have two tables:
Live:
Load
[Customer #] as CustomerNumber,
[address line 1] as Address1,
[address line 2] as Address2,
[address line 3] as Address3,
[address line 4] as Address4,
[address line 5] as Address5
From
Towns:
Load
[Invalid town]
From
I need something similar to "Like" where i can search each address field to see if it contains any of the words in [Invalid town]. For example:
[Invalid Town] might contain the word "Peterborough" but the Address1 field might read '1 close rd, Peterborough' and i want that to be picked up
I would use EXISTS and NOT EXISTS but i'm not looking for an exact match. Can anyone help?