This blog show how we can use Wild Characters along with Like statement in the Select query. Wild characters include % _ [] etc
Syntax
Select Column_List
From Table
Where Column1 Like '%Condition'
Example:
Select EmpName, Empsal
From Emptable
Where EmpName Like 'Kar%'