Sum of decimal values that come in a string Is there an easy way to get the sum of all decimal values in a string column.

Example:

"ABC $3.25, DEF $2.50, HIJ2 $0.25"
"ABC1 $3.25, DEF $2.50, HIJ $0.25, KLM $4.50"


I want to add only the values after the $ and before a ,.

Any help is highly appreciated.
If your SQL version is 2016 or later, you could try to use STRING_SPLIT function.
Against earlier version, there are also lots of impletmentations of string split by searching GG.

Below is my example for SQL 2016+:

DECLARE @v nvarchar(256) = N'ABC $3.25, DEF $2.50, HIJ2 $0.25,ABC1 $3.25, DEF $2.50, HIJ $0.25, KLM $4.50'
SELECT  TRIM(value), RIGHT(value, LEN(value)-CHARINDEX('$',value))
FROM    STRING_SPLIT(@v,',')
SELECT  SUM(CONVERT(decimal(10,2),RIGHT(value, LEN(value)-CHARINDEX('$',value))))
FROM    STRING_SPLIT(@v,',')