What would be the best way to parse data multiple times from a column?
ABC EFG HIK123456789 01
When this substring is run, we get some of the data
LTRIM(RTRIM(substring(column, CHARINDEX(' ', column, CHARINDEX(' ', column)+1), 5)))
But how do we get the last two numbers (01) from the string?
View Complete Post