sql like with contains code example

Example 1: 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

Example 2: like in sql

(Like) Operator for partial searches using wildcard '%' and '_'
For Example:
Select * From Employees
Where last_name LIKE '_a%';