SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (
  col1 varchar(max)
);

insert into mytable values
('[207.0, 206.8, 205.6]');
1 rows affected

SELECT
replace(replace(replace(col1, '[', ''), ']', ''), ' ', '') as VALUE
FROM       mytable


VALUE


207.0,206.8,205.6


SELECT *
FROM mytable
CROSS  APPLY STRING_SPLIT(replace(replace(replace(col1, '[', ''), ']', ''), ' ', ''), ',') AS f


col1
value


[207.0, 206.8, 205.6]
207.0

[207.0, 206.8, 205.6]
206.8

[207.0, 206.8, 205.6]
205.6


select t.col1, s.value
from mytable t
CROSS APPLY openjson(t.col1,'strict $') as s


col1
value


[207.0, 206.8, 205.6]
207.0

[207.0, 206.8, 205.6]
206.8

[207.0, 206.8, 205.6]
205.6

col1	value
[207.0, 206.8, 205.6]	207.0
[207.0, 206.8, 205.6]	206.8
[207.0, 206.8, 205.6]	205.6