Like Operator

This operator can be use to search for specified pattern from data set.
Example
Select * From EMP_DATABASE Where EMP_Name LIKE 'R%'
Displays the result where Employee name start with R alphabet

Select * From EMP_DATABASE Where EMP_Name LIKE '%R'
Displays the result where Employee name ends with R alphabet

Select * From EMP_DATABASE Where EMP_Name LIKE '%R%'
Displays the result where Employee name contains R alphabet