I'm parsing a column of text which separates the data by "." - VALUE1.VALUE2.VALUE3.VALUE4
I can get VALUE1 with SELECT SUBSTRING(COLUMN, 1, CHARINDEX('.', COLUMN + '.') - 1)
I can get VALUE4 using REVERSE but I can not isolate the middle 2 & 3.
The closest I've gotten is with SELECT SUBSTRING(COLUMN, CHARINDEX('.',COLUMN) + 1, CHARINDEX('.',COLUMN)+CHARINDEX('.',COLUMN)) which returns VALUE2.VALUE3.
Ideally I want to substring each separately so I can assign individual names for them.
Thanks in advanced,