What will be the output of below Substring function?

Select Substring('Vishal Kumar',7,6) as Portion;

 Posted by vishalneeraj-24503 on 1/24/2014 | Category: Sql Server Interview questions | Views: 1888 | Points: 40
Answer:

Output would be: Kumar

Here,we have specified start position as 7 and length is 6,so substring function will start counting from 7 upto 6.So it will return Kumar.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response