SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE #OneMillion (n integer NOT NULL);
INSERT #OneMillion WITH (TABLOCKX) (n)
SELECT 1
FROM master.dbo.spt_values AS SV1
CROSS JOIN master.dbo.spt_values AS SV2
WHERE SV1.[type] = N'P'
AND SV2.[type] = N'P'
AND SV1.number BETWEEN 0 AND 999
AND SV2.number BETWEEN 0 AND 999;

CREATE CLUSTERED COLUMNSTORE INDEX cci ON #OneMillion WITH (MAXDOP = 1);

SELECT row_count = COUNT_BIG(*) FROM #OneMillion AS OM;


row_count


1000000


CREATE TABLE dbo.test
(
  id integer NOT NULL,
  t_field varchar(100) NOT NULL
);

INSERT INTO test 
VALUES
(1, 'bar$foo$john$doe$xxx');

CREATE CLUSTERED COLUMNSTORE INDEX cci ON dbo.test WITH (MAXDOP = 1);
1 rows affected

SET NOCOUNT ON;

DECLARE @start datetime2(7) = SYSUTCDATETIME();
DECLARE @result varchar(100);

SELECT @result = REVERSE(CA3.result)
FROM dbo.test AS T
CROSS APPLY (SELECT REVERSE(T.t_field) COLLATE Latin1_General_100_BIN2) AS CA1 (s)
CROSS APPLY (SELECT CHARINDEX('$', CA1.s)) AS CA2 (pos)
CROSS APPLY (SELECT STUFF(CA1.s, CA2.pos, 1, '-')) AS CA3 (result)
JOIN #OneMillion AS OM
    ON OM.n = T.id
OPTION (MAXDOP 1);

SELECT elapsed_ms = DATEDIFF(MILLISECOND, @start, SYSUTCDATETIME());


elapsed_ms


93