Hi,

Is this the sort of thing that you're trying to achieve?

DECLARE @table TABLE (raw_payload VARCHAR(200))

INSERT INTO @table VALUES('UV+ 142.0000+ 0.0000')

INSERT INTO @table VALUES('UVN+ 524.0000+ 0.0000')

INSERT INTO @table VALUES('UVN+ 525.0000+ 0.0000')

INSERT INTO @table VALUES('UVN+ 527.0000+ 0.0000')

INSERT INTO @table VALUES('UVN+ 528.0000+ 0.0000')

INSERT INTO @table VALUES('TLOV+2044.0000+ 0.0000')

INSERT INTO @table VALUES('TLOV+2045.0000+ 0.0000')

INSERT INTO @table VALUES('OTD/ROV+2446.0000+ 0.0000')

INSERT INTO @table VALUES('G59WO+5324.0000+ 36.6190')

INSERT INTO @table VALUES('TLMLV+5601.0000+ 0.0000')

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

HTH, 😀