By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH AbundanceImpact(C)
AS
(
SELECT 'Monetary~50' UNION ALL
SELECT 'Monetary~120' UNION ALL
SELECT 'Monetary~200' UNION ALL
SELECT 'Monetary~269.90' UNION ALL
SELECT 'Monetary~125' UNION ALL
SELECT 'Magnanimous~50' UNION ALL
SELECT 'Monetary~22.05' UNION ALL
SELECT 'Unlimited~500' UNION ALL
SELECT 'Monetary~150' UNION ALL
SELECT 'Monetary~300' UNION ALL
SELECT 'Monetary~21.89' UNION ALL
SELECT 'Monetary~10.95'
)
SELECT SUM(CAST(RIGHT(C,LEN(C) - CHARINDEX('~',C,0)) AS FLOAT))
FROM AbundanceImpact
| (No column name) |
|---|
| 1819.79 |