GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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 06:55:27 #1
 mv_sivavardhan   Member Since: August 2008    Total Comments: 6 

RE: Single Row Function
 

select * from tbl_users with(nolock)

where right(username,1)=left(username,1)

     

 

Back To Question