What do we mean by Substring function in Sql Server?

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

Substring function is a Sql Server in-built function which is used to extract a portion of text or character from a given string.We can get any characters from withing any string value.

Syntax:
Substring(string_expression,string_start_position,string_length);


Where:
string_expression: It would be any string value from which we will extract portion.

string_start_position: It is an integer value that specifies from which position,the substring begin.The first position is the 1.

string_length: It specified the count of characters.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response