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

August 08, 2008 03:03:19	#2
msrao226	Member Since: August 2008 Total Comments: 1
RE: Single Row Function
select * from tbl_users with(nolock) where substr(username,1,1)=substr(username,-1,1)

Back To Question