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


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