SQL Server Transact Basic to Expert - Select Query with WildCard And Like

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%'