Hello All,
Need your help. I have source column data having mixed values as below and need output as shown in Result column
DDL and sample data population, start
DECLARE @tbl TABLE (tokens VARCHAR(100));
INSERT INTO @tbl (tokens) VALUES
('>4.2'),
('<6.0'),
('5.0 is max'),
('dup'),
('&5'),
('1');DDL and sample data population, end
Result
4.3
5.9
5.0 is max
dup
&5
1
If it sees numeric data with Greater Than then it should add 0.1
If it sees numeric data with Less Than then it should substract 0.1
Rest all data remain as it is.
I am using SQL Server 2016 version. Table data having millions of rows.
T.I.A