By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE DataTableOne (
ID int,
DATA varchar(MAX)
);
INSERT INTO DataTableOne (ID, DATA)
VALUES (1, '{"name":"Cole", "update_date":"2855290000"}'),
(2, '{"name":"Peter", "update_date":"1222290000"}'),
(3, '{"name":"Bob", "confirmation_date":"1222290000"}');
3 rows affected
select * from DataTableOne
where try_cast ( substring( data
, charindex('"update_date":', data)+15
, len(data)- (charindex('"update_date":', data)+15) -1 )
as bigint ) > 1645290000;
| ID | DATA |
|---|---|
| 1 | {"name":"Cole", "update_date":"2855290000"} |