Sql Query to return name with First letter and Last letter is same

Sql Query to return name with First letter and Last letter is same

Consider below details are in the table - StudentTest

Below Query is used to return name with both First and Last letter is same


SELECT * FROM studenttest WHERE Substring([StudentName], 1, 1) =  Substring([StudentName],LEN(STUDENTNAME), LEN(STUDENTNAME))