Use of LIKE Operator in SQL

·         Use of LIKE Operator:

--   Using LIKE Operator which prints empname starts from r

select * from Employee where EmployeeCode  LIKE 'r%'

--   Using LIKE Operator which prints empname ends with h

select * from Employee where EmployeeCode LIKE '%d'

--   it shows the names starts with m and r.

select *from employee where EmployeeCode LIKE '[m-r]%'

--   Using LIKE operator which prints empname which contains ra in their name

select * from Employee where EmployeeCode LIKE '%ra%'

--THE LIKE operator which prints empname which Doesnt contains ra in their name

select * from Employee where EmployeeCode NOT LIKE '%ra%'