Substring function example to get particular part of string in SQL Server

Introduction: 

In this article I will explain what is the substring function and uses of substring function in SQL Server.

Description:

During write query in SQL server I got requirement like split the string and get only some part of it to achieve this functionality I realized it’s better to use SubString function. 

SubString function:

This function is used to get the specified length of string based on specification of start position and required length of string. Generally SubString function will take 3 arguments.

Declaration of SubString function:

SUBSTRING(string, startIndex, length)

In this function

1^st Argument specifies the string value

2^nd Argument specifies the start position of string from where part of string begins

3^rd Argument specifies number of characters to be returned from the specified string

Examples of SubString Function:

EX1:

SELECT SUBSTRING('Suresh Dasari',1,10)

Output: 'Suresh Das'

In above query we declared string as 'Suresh Dasari', starting position of string as 1 and number of characters returned from string as 10

EX2:

SELECT SUBSTRING('Suresh Dasari',3,7)

Output:  'resh Da'

In above query string as 'Suresh Dasari', starting position of string as 3 and number of characters returned from string as 7

Ex3:

Suppose if we want split the column in table then our function declaration will be like this

SELECT SUBSTRING(ColumnName,1,4) as 'SubString' FROM TableName

ex: SELECT SUBSTRING(UserName,1,4) as 'SubString' FROM UserInformation

Above query will return UserName starting from 1 and return 4 characters from string like this

Output:   

SubString

Sure

Mahe

Naga

Mahe

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email