SELECT * FROM table WHERE column LIKE '%value%';
SELECT * FROM table WHERE value LIKE column;
SELECT * FROM table WHERE column LIKE '%value%' OR value LIKE column;
SELECT * FROM table WHERE column LIKE '%0123456%' OR 0123456 LIKE column;
SELECT * FROM table WHERE charindex(column,'0123456')>0 OR charindex('0123456',column)>0
SELECT * FROM table WHERE column LIKE '%' + @Value + '%' OR @Value LIKE '%' + column + '%'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)