By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
model_interested VARCHAR(100)
);
INSERT INTO test VALUES
('[{"key":"value","model":"A123","key":"value"}]');
1 rows affected
SELECT SUBSTRING(model_interested, CHARINDEX('"model":"', model_interested) + LEN('"model":"'), CHARINDEX('"', model_interested, CHARINDEX('"model":"', model_interested) + LEN('"model":"')) - (CHARINDEX('"model":"', model_interested) + LEN('"model":"')))
FROM test
| (No column name) |
|---|
| A123 |
SELECT SUBSTRING(model_interested, CHARINDEX('"model":"', model_interested), CHARINDEX('"', model_interested, CHARINDEX('"model":"', model_interested) + LEN('"model":"')) - CHARINDEX('"model":"', model_interested) + 1)
FROM test
| (No column name) |
|---|
| "model":"A123" |
SELECT JSON_VALUE(REPLACE(REPLACE(model_interested, '{[', '[{'), ']}', '}]'), '$[0].model')
FROM test
| (No column name) |
|---|
| A123 |