How to get the list of students whose name starts and ends with the same character in a single column

Vote count:

1

SELECT StudentName FROM tblStudents WHERE StudentName like 'a%' and StudentName like '%a'

I am getting the list of records whose letter starts with specific character A, but i am not able to get the list of all the students from the letter A to Z.

asked 43 secs ago

Vikas Hooda

24

How to get the list of students whose name starts and ends with the same character in a single column