declare @a varchar(100)
set @a = '6125.349.5601.278.90.black.blue'
The variable @a hold seven different values seperated by '.'
I have a table where a column holds data whoose pattern is exactly like above.
Now I want to break the abve value into seven different columns.
All the values should be shown in one row.
Is it possible to do this without using function?
Is it possible to do through select statement?
I want to update the table having columns value1,value2, value3,value4,value5,value6,value7