SQL Server Get String Before and After Character (Delimiter) Example

Introduction:

Here I will explain how to get string before and after character in sql server with example or sql server get string before or after character / delimiter example. By using CHARINDEX and SUBSTRING properties we can get string before or after character in sql server.

Description:

In previous articles I explained sql server check if string contains specific word or not, sql server query to read xml data file, single stored procedure to create, update, delete operations in sql server, SQL Server insert multiple records with one insert statement, SQL Server restore database from .bak / .mdf file and many articles relating to SQL server. Now I will explain how to get string before or after character or delimiter in sql server with example.

To get string before or after character or delimiter in sql server we need to write the code like as shown below

Select id ,LEFT(name, CHARINDEX(',', name) - 1) AS Firstname ,REPLACE(SUBSTRING(name, CHARINDEX(',', name), LEN(name)), ',', '') AS Lastname from @temp

If you want complete working example check following query

DECLARE @temp table(id int, name varchar(50)) insert into @temp(id,name) values(1,'Suresh,Dasari'), (2,'Rohini,Alavala'), (3,'Madhav,Sai') Select id ,LEFT(name, CHARINDEX(',', name) - 1) AS Firstname ,REPLACE(SUBSTRING(name, CHARINDEX(',', name), LEN(name)), ',', '') AS Lastname from @temp

If we execute above query we will get string before and after character comma (,) and output like as shown below

Output

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