I am fairly new to TSQL and need some urgent help on this.
I have a column in a table made up of a string that has data as follows:
I would like to break the long string into different words and then store them in separate columns, so I should have
Column 1: COSTS
Column 2: LEVEL
Column 3: GRADE
Column 4: ITEM
Can someone please help me out with this, taking into consideration the fact that I am a newbie to TSQL.
View Complete Post