SQL Server 2014

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

SELECT @@version;


(No column name)


Microsoft SQL Server 2014 (SP3-CU-GDR) (KB4535288) - 12.0.6372.1 (X64) 
	Dec 12 2019 15:14:11 
	Copyright (c) Microsoft Corporation
	Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE test
(
    id int,
    data varchar(MAX)
);
INSERT INTO test (id, data) VALUES 
(1, '{"name":"Cole", "update_date":"2855290000"}'),   -- >> search condition (sc)! out of bounds
(2, '{"name":"Peter", "update_date":"1222290000"}'),                  -- << sc
(3, '{"name":"A Very Long Silly Name", "update_date":"1635290000"}'), -- < sc 
(4, '{"name":"A Long Name", "update_date":"1645290000"}'),            -- = sc
(5, '{"name":"A Name ", "update_date":"1645390000"}'),                -- > sc 
(6, '{"name":"An Ordinary Name", "update_date":"2147483647"}'),       -- >> sc
(7, '{"name":"Some Other Name", "update_date":"2147483648"}'),        -- out of bounds by 1s
(8, '{"name":"A Name Yet Again", "update_date":"1545290000784"}');   -- out of bounds 

                                   -- last update_date is above  is > 1645290000 but
                                   -- > 1645290000 for the first 10 characters!
                                                                 
8 rows affected

INSERT INTO test (id, data) VALUES
(9, '{"name":"A Name Yet Again", "update_date":"15452900007843435"}'),
(10, '{"name":"A Name Yet Again", "update_date":"154529000078434353434343334"}');
2 rows affected

SELECT 
  CHARINDEX('"', REVERSE(data)),
  CHARINDEX('"', REVERSE(data), 5) -- 5 is arbitrary.
FROM
  test;


(No column name)
(No column name)


2
13

2
13

2
13

2
13

2
13

2
13

2
13

2
16

2
20

2
30


SELECT
  SUBSTRING
  (
    REVERSE(data), 
    CHARINDEX('"', REVERSE(data)) + 1,
    CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) - 1
  )
FROM 
  test;


(No column name)


0000925582

0000922221

0000925361

0000925461

0000935461

7463847412

8463847412

4870000925451

53434870000925451

433343434353434870000925451


SELECT
  REVERSE
  (
    SUBSTRING
    (
      REVERSE(data), 
      CHARINDEX('"', REVERSE(data)) + 1,
      CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
    )
  ) 
FROM 
  test;


(No column name)


2855290000

1222290000

1635290000

1645290000

1645390000

2147483647

2147483648

1545290000784

15452900007843435

154529000078434353434343334


SELECT
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) 
FROM 
  test;


(No column name)


null

1222290000

1635290000

1645290000

1645390000

2147483647

null

null

null

null


--
-- Vérace's solution
--

SELECT
  id, data,
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) AS int_condition
FROM test
WHERE 
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) > 1645290000;


id
data
int_condition


5
{"name":"A Name ", "update_date":"1645390000"}
1645390000

6
{"name":"An Ordinary Name", "update_date":"2147483647"}
2147483647


--
-- Lennart's solution!
--

SELECT
  *,
  LEN(data),
  charindex('"update_date":', data) + 15,
  len(data)- (charindex('"update_date":', data) + 15) - 1,
  TRY_CAST 
  ( 
    substring
    ( 
      data
      , charindex('"update_date":', data) + 15
      , len(data)- (charindex('"update_date":', data) + 15) - 1 
    )
    as bigint 
  )
  
  
FROM test
where 
  TRY_CAST 
  ( 
    substring
    ( 
      data
      , charindex('"update_date":', data)+15
      , len(data)- (charindex('"update_date":', data)+15) -1 
    )
    as bigint 
  ) > 1645290000;


id
data
(No column name)
(No column name)
(No column name)
(No column name)


1
{"name":"Cole", "update_date":"2855290000"}
43
32
10
2855290000

5
{"name":"A Name ", "update_date":"1645390000"}
46
35
10
1645390000

6
{"name":"An Ordinary Name", "update_date":"2147483647"}
55
44
10
2147483647

7
{"name":"Some Other Name", "update_date":"2147483648"}
54
43
10
2147483648

8
{"name":"A Name Yet Again", "update_date":"1545290000784"}
58
44
13
1545290000784

9
{"name":"A Name Yet Again", "update_date":"15452900007843435"}
62
44
17
15452900007843435


--
-- Lennart's solution with tiny revision.
--

SELECT
  *,
  LEN(data),
  charindex(', "update_date":"', data) + 17,
  len(data)- (charindex(', "update_date":"', data) + 17) - 1,
  TRY_CAST 
  ( 
    substring
    ( 
      data
      , charindex(', "update_date":"', data) + 17
      , len(data)- (charindex(', "update_date":"', data) + 17) - 1 
    )
    as bigint 
  )
  
  
FROM test
where 
  TRY_CAST 
  ( 
    substring
    ( 
      data
      , charindex(', "update_date":"', data) + 17
      , len(data)- (charindex(', "update_date":"', data) + 17) -1 
    )
    as bigint 
  ) > 1645290000;


id
data
(No column name)
(No column name)
(No column name)
(No column name)


1
{"name":"Cole", "update_date":"2855290000"}
43
32
10
2855290000

5
{"name":"A Name ", "update_date":"1645390000"}
46
35
10
1645390000

6
{"name":"An Ordinary Name", "update_date":"2147483647"}
55
44
10
2147483647

7
{"name":"Some Other Name", "update_date":"2147483648"}
54
43
10
2147483648

8
{"name":"A Name Yet Again", "update_date":"1545290000784"}
58
44
13
1545290000784

9
{"name":"A Name Yet Again", "update_date":"15452900007843435"}
62
44
17
15452900007843435


SELECT
    DTO.*
FROM dbo.test AS DTO
CROSS APPLY 
(
    SELECT 
        TRY_CONVERT(xml,
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(DTO.[DATA], 
                            '"name":', 'name='),
                        ', "update_date":', ' update_date='),
                    '{', '<r '),
                '}', '/>'))
) AS X (x)
WHERE
    1 = X.x.exist('r[1][@update_date ge 1645290000]');


id
data


1
{"name":"Cole", "update_date":"2855290000"}

4
{"name":"A Long Name", "update_date":"1645290000"}

5
{"name":"A Name ", "update_date":"1645390000"}

6
{"name":"An Ordinary Name", "update_date":"2147483647"}

7
{"name":"Some Other Name", "update_date":"2147483648"}

8
{"name":"A Name Yet Again", "update_date":"1545290000784"}

9
{"name":"A Name Yet Again", "update_date":"15452900007843435"}

10
{"name":"A Name Yet Again", "update_date":"154529000078434353434343334"}


SELECT
  DATEADD
  (
    SECOND, 
    TRY_CAST
    (
      REVERSE
      (
        SUBSTRING
        (
          REVERSE(data), 
          CHARINDEX('"', REVERSE(data)) + 1,
          CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
        )
      ) AS INT)
    
    , '19700101'  
  )
FROM
  test;


(No column name)


null

2008-09-24 21:00:00.000

2021-10-26 23:13:20.000

2022-02-19 17:00:00.000

2022-02-20 20:46:40.000

2038-01-19 03:14:07.000

null

null

null

null


SET STATISTICS TIME, PROFILE, IO ON;
SELECT
  id, data,
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) AS int_condition
FROM test
WHERE 
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) > 1645290000;


id
data
int_condition


5
{"name":"A Name ", "update_date":"1645390000"}
1645390000

6
{"name":"An Ordinary Name", "update_date":"2147483647"}
2147483647


SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.




Rows
Executes
StmtText
StmtId
NodeId
Parent
PhysicalOp
LogicalOp
Argument
DefinedValues
EstimateRows
EstimateIO
EstimateCPU
AvgRowSize
TotalSubtreeCost
OutputList
Warnings
Type
Parallel
EstimateExecutions


2
1
SELECT
  id, data,
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) AS int_condition
FROM test
WHERE 
  TRY_CAST
  (
    REVERSE
    (
      SUBSTRING
      (
        REVERSE(data), 
        CHARINDEX('"', REVERSE(data)) + 1,
        CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1
      )
    ) AS INT) > 1645290000
1
1
0
null
null
null
null
3
null
null
null
0.0032951
null
null
SELECT
False
null

0
0
  |--Compute Scalar(DEFINE:([Expr1003]=TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)))
1
2
1
Compute Scalar
Compute Scalar
DEFINE:([Expr1003]=TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int))
[Expr1003]=TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)
3
0
3E-07
4043
0.0032951
[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data], [Expr1003]
null
PLAN_ROW
False
1

2
1
       |--Filter(WHERE:(TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)>(1645290000)))
1
3
2
Filter
Filter
WHERE:(TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)>(1645290000))
null
3
0
1.8E-06
4039
0.0032948
[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]
null
PLAN_ROW
False
1

10
1
            |--Table Scan(OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test]))
1
4
3
Table Scan
Table Scan
OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test])
[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]
10
0.0032035
8.95E-05
4039
0.003293
[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]
null
PLAN_ROW
False
1


Table 'test'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.


SELECT
    DTO.*
FROM dbo.test AS DTO
CROSS APPLY 
(
    SELECT 
        TRY_CONVERT(xml,
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(DTO.[DATA], 
                            '"name":', 'name='),
                        ', "update_date":', ' update_date='),
                    '{', '<r '),
                '}', '/>'))
) AS X (x)
WHERE
    1 = X.x.exist('r[1][@update_date ge 1645290000]');


id
data


1
{"name":"Cole", "update_date":"2855290000"}

4
{"name":"A Long Name", "update_date":"1645290000"}

5
{"name":"A Name ", "update_date":"1645390000"}

6
{"name":"An Ordinary Name", "update_date":"2147483647"}

7
{"name":"Some Other Name", "update_date":"2147483648"}

8
{"name":"A Name Yet Again", "update_date":"1545290000784"}

9
{"name":"A Name Yet Again", "update_date":"15452900007843435"}

10
{"name":"A Name Yet Again", "update_date":"154529000078434353434343334"}


SQL Server parse and compile time: 
   CPU time = 0 ms, elapsed time = 0 ms.




Rows
Executes
StmtText
StmtId
NodeId
Parent
PhysicalOp
LogicalOp
Argument
DefinedValues
EstimateRows
EstimateIO
EstimateCPU
AvgRowSize
TotalSubtreeCost
OutputList
Warnings
Type
Parallel
EstimateExecutions


8
1
SELECT
    DTO.*
FROM dbo.test AS DTO
CROSS APPLY 
(
    SELECT 
        TRY_CONVERT(xml,
            REPLACE(
                REPLACE(
                    REPLACE(
                        REPLACE(DTO.[DATA], 
                            '"name":', 'name='),
                        ', "update_date":', ' update_date='),
                    '{', '<r '),
                '}', '/>'))
) AS X (x)
WHERE
    1 = X.x.exist('r[1][@update_date ge 1645290000]')
1
1
0
null
null
null
null
9
null
null
null
9.052214
null
null
SELECT
False
null

8
1
  |--Nested Loops(Left Semi Join, OUTER REFERENCES:([DTO].[data]))
1
2
1
Nested Loops
Left Semi Join
OUTER REFERENCES:([DTO].[data])
null
9
0
3.762E-05
93
9.052214
[DTO].[id], [DTO].[data]
null
PLAN_ROW
False
1

10
1
       |--Filter(WHERE:([Expr1013] IS NOT NULL))
1
3
2
Filter
Filter
WHERE:([Expr1013] IS NOT NULL)
null
9
0
4.8E-06
93
0.0032988
[DTO].[id], [DTO].[data]
null
PLAN_ROW
False
1

0
0
       |    |--Compute Scalar(DEFINE:([Expr1013]=TRY_CAST(replace(replace(replace(replace([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data] as [DTO].[data],'"name":',CONVERT_IMPLICIT(varchar(max),'name=',0)),', "update_date":',CONVERT_IMPLICIT(varchar(max),' update_date=',0)),'{',CONVERT_IMPLICIT(varchar(max),'<r ',0)),'}',CONVERT_IMPLICIT(varchar(max),'/>',0)) AS xml)))
1
4
3
Compute Scalar
Compute Scalar
DEFINE:([Expr1013]=TRY_CAST(replace(replace(replace(replace([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data] as [DTO].[data],'"name":',CONVERT_IMPLICIT(varchar(max),'name=',0)),', "update_date":',CONVERT_IMPLICIT(varchar(max),' update_date=',0)),'{',CONVERT_IMPLICIT(varchar(max),'<r ',0)),'}',CONVERT_IMPLICIT(varchar(max),'/>',0)) AS xml))
[Expr1013]=TRY_CAST(replace(replace(replace(replace([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data] as [DTO].[data],'"name":',CONVERT_IMPLICIT(varchar(max),'name=',0)),', "update_date":',CONVERT_IMPLICIT(varchar(max),' update_date=',0)),'{',CONVERT_IMPLICIT(varchar(max),'<r ',0)),'}',CONVERT_IMPLICIT(varchar(max),'/>',0)) AS xml)
10
0
1E-06
4119
0.003294
[DTO].[id], [DTO].[data], [Expr1013]
null
PLAN_ROW
False
1

10
1
       |         |--Table Scan(OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test] AS [DTO]))
1
5
4
Table Scan
Table Scan
OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test] AS [DTO])
[DTO].[id], [DTO].[data]
10
0.003125
0.000168
93
0.003293
[DTO].[id], [DTO].[data]
null
PLAN_ROW
False
1

8
10
       |--Nested Loops(Left Semi Join, OUTER REFERENCES:(XML Reader with XPath filter.[id], [Expr1015]))
1
10
2
Nested Loops
Left Semi Join
OUTER REFERENCES:(XML Reader with XPath filter.[id], [Expr1015])
null
1
0
4.18E-06
9
9.048878
null
null
PLAN_ROW
False
9

10
10
            |--Top(TOP EXPRESSION:((1)))
1
11
10
Top
Top
TOP EXPRESSION:((1))
null
1
0
1E-07
913
0.04518196
XML Reader with XPath filter.[id], [Expr1015]
null
PLAN_ROW
False
9

0
0
            |    |--Compute Scalar(DEFINE:([Expr1007]=0x58, [Expr1015]=getdescendantlimit(XML Reader with XPath filter.[id])))
1
12
11
Compute Scalar
Compute Scalar
DEFINE:([Expr1007]=0x58, [Expr1015]=getdescendantlimit(XML Reader with XPath filter.[id]))
[Expr1007]=0x58, [Expr1015]=getdescendantlimit(XML Reader with XPath filter.[id])
1
0
2E-05
1365
0.04518105
XML Reader with XPath filter.[id], [Expr1007], [Expr1015]
null
PLAN_ROW
False
9

10
10
            |         |--Table-valued function
1
13
12
Table-valued function
Table-valued function
null
null
1
0
1.004
461
0.04518016
XML Reader with XPath filter.[id]
null
PLAN_ROW
False
9

8
10
            |--Filter(WHERE:(XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1)) AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0)) IS NOT NULL AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0))>=1.64529e+009))
1
24
10
Filter
Filter
WHERE:(XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1)) AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0)) IS NOT NULL AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0))>=1.64529e+009)
null
1
0
4.644E-05
9
9.003658
null
null
PLAN_ROW
False
9

10
10
                 |--Table-valued function
1
25
24
Table-valued function
Table-valued function
null
null
18
0
1.00036
8501
9.00324
XML Reader with XPath filter.[id], XML Reader with XPath filter.[tid], XML Reader with XPath filter.[value], XML Reader with XPath filter.[lvalue]
null
PLAN_ROW
False
9


Table 'test'. Scan count 1, logical reads 1, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

id	data	int_condition
5	{"name":"A Name ", "update_date":"1645390000"}	1645390000
6	{"name":"An Ordinary Name", "update_date":"2147483647"}	2147483647

id	data	(No column name)	(No column name)	(No column name)	(No column name)
1	{"name":"Cole", "update_date":"2855290000"}	43	32	10	2855290000
5	{"name":"A Name ", "update_date":"1645390000"}	46	35	10	1645390000
6	{"name":"An Ordinary Name", "update_date":"2147483647"}	55	44	10	2147483647
7	{"name":"Some Other Name", "update_date":"2147483648"}	54	43	10	2147483648
8	{"name":"A Name Yet Again", "update_date":"1545290000784"}	58	44	13	1545290000784
9	{"name":"A Name Yet Again", "update_date":"15452900007843435"}	62	44	17	15452900007843435

id	data
1	{"name":"Cole", "update_date":"2855290000"}
4	{"name":"A Long Name", "update_date":"1645290000"}
5	{"name":"A Name ", "update_date":"1645390000"}
6	{"name":"An Ordinary Name", "update_date":"2147483647"}
7	{"name":"Some Other Name", "update_date":"2147483648"}
8	{"name":"A Name Yet Again", "update_date":"1545290000784"}
9	{"name":"A Name Yet Again", "update_date":"15452900007843435"}
10	{"name":"A Name Yet Again", "update_date":"154529000078434353434343334"}

Rows	Executes	StmtText	StmtId	NodeId	Parent	PhysicalOp	LogicalOp	Argument	DefinedValues	EstimateRows	EstimateIO	EstimateCPU	AvgRowSize	TotalSubtreeCost	OutputList	Warnings	Type	Parallel	EstimateExecutions
2	1	SELECT id, data, TRY_CAST ( REVERSE ( SUBSTRING ( REVERSE(data), CHARINDEX('"', REVERSE(data)) + 1, CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1 ) ) AS INT) AS int_condition FROM test WHERE TRY_CAST ( REVERSE ( SUBSTRING ( REVERSE(data), CHARINDEX('"', REVERSE(data)) + 1, CHARINDEX('"', REVERSE(data), 5) - CHARINDEX('"', REVERSE(data)) -1 ) ) AS INT) > 1645290000	1	1	0	null	null	null	null	3	null	null	null	0.0032951	null	null	SELECT	False	null
0	0	\|--Compute Scalar(DEFINE:([Expr1003]=TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)))	1	2	1	Compute Scalar	Compute Scalar	DEFINE:([Expr1003]=TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int))	[Expr1003]=TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)	3	0	3E-07	4043	0.0032951	[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data], [Expr1003]	null	PLAN_ROW	False	1
2	1	\|--Filter(WHERE:(TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)>(1645290000)))	1	3	2	Filter	Filter	WHERE:(TRY_CAST(reverse(substring(reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))+(1),charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]),(5))-charindex('"',reverse([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]))-(1))) AS int)>(1645290000))	null	3	0	1.8E-06	4039	0.0032948	[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]	null	PLAN_ROW	False	1
10	1	\|--Table Scan(OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test]))	1	4	3	Table Scan	Table Scan	OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test])	[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]	10	0.0032035	8.95E-05	4039	0.003293	[fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[id], [fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data]	null	PLAN_ROW	False	1

Rows	Executes	StmtText	StmtId	NodeId	Parent	PhysicalOp	LogicalOp	Argument	DefinedValues	EstimateRows	EstimateIO	EstimateCPU	AvgRowSize	TotalSubtreeCost	OutputList	Warnings	Type	Parallel	EstimateExecutions
8	1	SELECT DTO.* FROM dbo.test AS DTO CROSS APPLY ( SELECT TRY_CONVERT(xml, REPLACE( REPLACE( REPLACE( REPLACE(DTO.[DATA], '"name":', 'name='), ', "update_date":', ' update_date='), '{', '<r '), '}', '/>')) ) AS X (x) WHERE 1 = X.x.exist('r[1][@update_date ge 1645290000]')	1	1	0	null	null	null	null	9	null	null	null	9.052214	null	null	SELECT	False	null
8	1	\|--Nested Loops(Left Semi Join, OUTER REFERENCES:([DTO].[data]))	1	2	1	Nested Loops	Left Semi Join	OUTER REFERENCES:([DTO].[data])	null	9	0	3.762E-05	93	9.052214	[DTO].[id], [DTO].[data]	null	PLAN_ROW	False	1
10	1	\|--Filter(WHERE:([Expr1013] IS NOT NULL))	1	3	2	Filter	Filter	WHERE:([Expr1013] IS NOT NULL)	null	9	0	4.8E-06	93	0.0032988	[DTO].[id], [DTO].[data]	null	PLAN_ROW	False	1
0	0	\| \|--Compute Scalar(DEFINE:([Expr1013]=TRY_CAST(replace(replace(replace(replace([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data] as [DTO].[data],'"name":',CONVERT_IMPLICIT(varchar(max),'name=',0)),', "update_date":',CONVERT_IMPLICIT(varchar(max),' update_date=',0)),'{',CONVERT_IMPLICIT(varchar(max),'<r ',0)),'}',CONVERT_IMPLICIT(varchar(max),'/>',0)) AS xml)))	1	4	3	Compute Scalar	Compute Scalar	DEFINE:([Expr1013]=TRY_CAST(replace(replace(replace(replace([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data] as [DTO].[data],'"name":',CONVERT_IMPLICIT(varchar(max),'name=',0)),', "update_date":',CONVERT_IMPLICIT(varchar(max),' update_date=',0)),'{',CONVERT_IMPLICIT(varchar(max),'<r ',0)),'}',CONVERT_IMPLICIT(varchar(max),'/>',0)) AS xml))	[Expr1013]=TRY_CAST(replace(replace(replace(replace([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test].[data] as [DTO].[data],'"name":',CONVERT_IMPLICIT(varchar(max),'name=',0)),', "update_date":',CONVERT_IMPLICIT(varchar(max),' update_date=',0)),'{',CONVERT_IMPLICIT(varchar(max),'<r ',0)),'}',CONVERT_IMPLICIT(varchar(max),'/>',0)) AS xml)	10	0	1E-06	4119	0.003294	[DTO].[id], [DTO].[data], [Expr1013]	null	PLAN_ROW	False	1
10	1	\| \|--Table Scan(OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test] AS [DTO]))	1	5	4	Table Scan	Table Scan	OBJECT:([fiddle_bfa03fd3943d4460bb28906d7261078b].[dbo].[test] AS [DTO])	[DTO].[id], [DTO].[data]	10	0.003125	0.000168	93	0.003293	[DTO].[id], [DTO].[data]	null	PLAN_ROW	False	1
8	10	\|--Nested Loops(Left Semi Join, OUTER REFERENCES:(XML Reader with XPath filter.[id], [Expr1015]))	1	10	2	Nested Loops	Left Semi Join	OUTER REFERENCES:(XML Reader with XPath filter.[id], [Expr1015])	null	1	0	4.18E-06	9	9.048878	null	null	PLAN_ROW	False	9
10	10	\|--Top(TOP EXPRESSION:((1)))	1	11	10	Top	Top	TOP EXPRESSION:((1))	null	1	0	1E-07	913	0.04518196	XML Reader with XPath filter.[id], [Expr1015]	null	PLAN_ROW	False	9
0	0	\| \|--Compute Scalar(DEFINE:([Expr1007]=0x58, [Expr1015]=getdescendantlimit(XML Reader with XPath filter.[id])))	1	12	11	Compute Scalar	Compute Scalar	DEFINE:([Expr1007]=0x58, [Expr1015]=getdescendantlimit(XML Reader with XPath filter.[id]))	[Expr1007]=0x58, [Expr1015]=getdescendantlimit(XML Reader with XPath filter.[id])	1	0	2E-05	1365	0.04518105	XML Reader with XPath filter.[id], [Expr1007], [Expr1015]	null	PLAN_ROW	False	9
10	10	\| \|--Table-valued function	1	13	12	Table-valued function	Table-valued function	null	null	1	0	1.004	461	0.04518016	XML Reader with XPath filter.[id]	null	PLAN_ROW	False	9
8	10	\|--Filter(WHERE:(XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1)) AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0)) IS NOT NULL AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0))>=1.64529e+009))	1	24	10	Filter	Filter	WHERE:(XML Reader with XPath filter.[id]=getancestor(XML Reader with XPath filter.[id],(1)) AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0)) IS NOT NULL AND xsd_cast(XML Reader with XPath filter.[value],XML Reader with XPath filter.[lvalue],XML Reader with XPath filter.[tid],(18),(75),(0))>=1.64529e+009)	null	1	0	4.644E-05	9	9.003658	null	null	PLAN_ROW	False	9
10	10	\|--Table-valued function	1	25	24	Table-valued function	Table-valued function	null	null	18	0	1.00036	8501	9.00324	XML Reader with XPath filter.[id], XML Reader with XPath filter.[tid], XML Reader with XPath filter.[value], XML Reader with XPath filter.[lvalue]	null	PLAN_ROW	False	9