@cheema11 wrote: Hi @Patrick. In response to your query...."What if a string in table A matches multiple substrings in table B?" My answer was "Return the one with longest string length in Table B. If string length is same, then return any one of them." What do i need to change in the script if I want to return the string with shortest length in Table B?
@PeterClemmensen did all the work getting the full requirements from you.
... View more
