sql ilike vs like code example
Example: sql contains vs like
SELECT * FROM table WHERE Column LIKE '%test%'; -- can't use index
SELECT * FROM table WHERE CONTAINS(Column, 'test'); -- faster with full text index
SELECT * FROM table WHERE Column LIKE '%test%'; -- can't use index
SELECT * FROM table WHERE CONTAINS(Column, 'test'); -- faster with full text index