SQL Server Get String Before and After Character (Delimiter) 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