Answer Detail: RE: Single Row Function

GeekInterview.com > Interview Questions > Database > SQL

Print |

Question: Single Row Function

Answer: Display details of employees having same char at the star and end postition of their name

like

abishika

this name have last character and first character is same

February 02, 2009 22:24:06	#8
kgoyal15	Member Since: February 2009 Total Comments: 1
RE: Single Row Function
SELECT * FROM table_users WHERE (LEFT(name, 1) = SUBSTRING(name, LEN(name), LEN(name)))

Back To Question