Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

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

Nov 20, 2015
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:

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 RSS subscribe by email Subscribe by Email

1 comments :

Tin Win said...

i like this.

Give your Valuable Comments

Other Related Posts

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.