CHARINDEX - PATINDEX - USAGE

SELECT

REPLACE(SplitRange,' ',''),

REPLACE(Range_Start,' ',''),

REPLACE(Range_End,' ',''),

REPLACE([year],' ','')

FROM

(

SELECT

--SUBSTRING([expressions], CHARINDEX('>=',[expressions]),CHARINDEX('<',[expressions])-CHARINDEX('>=',[expressions])+ Len('<')) as col1,

--SUBSTRING(expressions, PATINDEX('=', replace(expressions,' ','')), PATINDEX('<',replace(expressions,' ',''))),

SUBSTRING(expressions,1,1) as SplitRange,

SUBSTRING(expressions, CHARINDEX('=', expressions) + 1, 6)as Range_Start,

case

when expressions like '%<%' Then SUBSTRING(expressions, CHARINDEX('<', expressions) + 1, 6)

else ''

end

as Range_End,

right(expressions,5) as [year]

FROM #t_expressions

)X