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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : What will happen,when we execute below query? S ...

Next > : Give an example of SubString function?

Comments or Responses

More Interview Questions by vishalneeraj-24503

Give an example of SubString function?
What do we mean by Substring function in Sql Server?
How to rename sp_get_users_list to sp_get_all_list_of_users.
What is the use of sp_rename in Sql Server?
What are the type-conversion methods available in Dot Net?
How to drop any column from table?
How to modify table column datatype?
Give a simple example of Static class?

Latest Interview Questions

What will happen,if we run below query in query analizer? Select Mo ...
What is the return type of Month in-built sql server function?
What will be output of below query? Select Month('01/23/2014 ...
What is the use of Month in-built Sql-Server function?
How many joins are there in Sql-Server?
What are the types of Cursors?
What considerations must be there when working with Cursors?
How to remove leading space from below string? string name = " ...
More ...

What will be the output of below Substring function? Select Substring('Vishal Kumar',7,6) as Portion;

Comments or Responses

What will be the output of below Substring function?

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