Константин Цветков

DECLARE @ITEM VARCHAR(100) = '[ 3102, 3106]'
SELECT CAST( value AS INT ) AS ITEM 
  FROM STRING_SPLIT( SUBSTRING( @ITEM, 2, DATALENGTH( @ITEM ) - 2 ), ',')

SELECT MAX(start_diameter) FROM table_name WHERE (start_diameter <= 145)
UNION ALL
SELECT MIN(start_diameter) FROM table_name WHERE (start_diameter >= 145)