[SQL] dynamic like

SELECT column 
  FROM table AS T1
       INNER JOIN Params AS P1
          ON T1.column LIKE '%' + P1.param + '%';

https://stackoverflow.com/questions/4612282/dynamic-like-statement-in-sql

Dynamic Like Statement in SQL