Hi,
Could you please try the query below and let me know if it meets your requirements?
SELECT *
FROM TableA A
LEFT JOIN TableB B
ON A.Column1 LIKE REPLACE(B.Column1, '%', '%%')
Replace helps us in treating the %' stored in TableB.Column1 as a wildcard
Jahnavi N
