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

December 12, 2008 04:33:38	#6
PrernaK	Member Since: December 2008 Total Comments: 1
RE: Single Row Function
Select * from emp where upper(substr(ename,1,1)) = upper(substr(ename,-1,1))

Back To Question