display details of all the employee whose name contains the same character at start and end position at their names

Question

1.00/5 (1 vote)

See more:

table
id name

1 rama
2 arama
3 services

Posted 27-Jan-14 3:17am

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2014-01-27T03:31:00

SELECT * FROM tablename WHERE RIGHT(name ,1) = LEFT(name ,1)

Posted 27-Jan-14 3:31am

Comments

Karthik_Mahalingam 27-Jan-14 9:40am

5

Peter Leow 27-Jan-14 9:45am

Thanks Karthik.