22 May 2013

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))



No comments:

Post a Comment

Comments Welcome