Create below function
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[ParseValues]
(@String varchar(8000), @Delimiter varchar(10) )
RETURNS @RESULTS TABLE (ID int identity(1,1), Val varchar(50))
AS
BEGIN
DECLARE @Value varchar(100)
WHILE @String is not null
BEGIN
SELECT @Value=CASE WHEN PATINDEX('%'+@Delimiter+'%',@String) >0 THEN LEFT(@String,PATINDEX('%'+@Delimiter+'%',@String)-1) ELSE @String END, @String=CASE WHEN PATINDEX('%'+@Delimiter+'%',@String) >0 THEN SUBSTRING(@String,PATINDEX('%'+@Delimiter+'%',@String)+LEN(@Delimiter),LEN(@String)) ELSE NULL END
INSERT INTO @RESULTS (Val)
SELECT @Value
END
RETURN
END
Now execute below query...
DECLARE @String VARCHAR(MAX)
DECLARE @S VARCHAR(MAX)
SET @String = '1,1000,"1,1000",0,0,"1,125"'
select @S = COALESCE(@S, '') +case when charindex('"',val)>0 then case when charindex('"',val) > 1 then '' else '"' end else '' end
+
replace(val,'"','')
+
case when charindex('"',val)>0 then case when charindex('"',val) > 1 then '",' else '' end else ',' end
from dbo.parsevalues(@string,',')
select substring(@s,0,len(@s))
Happy Coding!
:)