I am answering to myself for the 2nd time but don't think I am fool! I have tried the TRANWRD solution but I am amazed by the time it takes: - with table A, totally burst, having 40 millions of combinations, the join on table B (which have about 90k lines) takes 2 minutes; - with table A, reduced with the "ANY" wildcard, having only 450k of combinations, the join on the same table B with TRANWRD function takes more than 15 minutes. It seems like I am making a cartesian product (the log says so). I think that anytime it finds the wildcard "ANY" in table A, then it joins on all records of table B. So issue is stille there... Note: the join is made on 7 variables.
... View more