This content has been marked as final. Show 3 replies
I have two tables
Name1 as Name,
ApplyMap('MapTable',Name,Null()) as Surname
Currently I am using apply map function to bring Surname into my sales table which works fine for exact matches.
I now need to do a "Wild Card" search within Name to return all surnames that contain the Name from Customers
eg. Name1 in the Customers table is 'John'
Name from the Sales table is 'Crazy John the 1 and only$'
This record must return Johns surname as John is within the Name in the sales table.
I appreciate your responses.