Tried this

DECLARE @table TABLE (raw_payload VARCHAR(200))

INSERT INTO @Table SELECT raw_payload FROM raw_data

SELECT LEFT(raw_payload, CHARINDEX('+', raw_payload, 1)-1),

CAST(SUBSTRING(raw_payload,

CHARINDEX('+', raw_payload, 1) + 1,

CHARINDEX('+', raw_payload, CHARINDEX('+', raw_payload, 1) +1) - (CHARINDEX('+', raw_payload, 1) + 1))

AS FLOAT),

CAST(SUBSTRING(raw_payload,

CHARINDEX('+', raw_payload, CHARINDEX('+', raw_payload, 1) +1) + 1,

LEN(raw_payload) - CHARINDEX('+', raw_payload, CHARINDEX('+', raw_payload, 1) +1) + 1)

AS FLOAT)

FROM @table

This is the result...

(2536030 row(s) affected)

Server: Msg 536, Level 16, State 3, Line 5

Invalid length parameter passed to the substring function.