select employee name start with 'a' without using "Like" operator.

This Blog show you Sql query to get employee name start with 'a' without using "Like" operator.

Here is the query to get employee name start with 'a' without using "Like" operator.


select * from Employee where CHARINDEX('a',EmpName)=1