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

Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...