Seperate the single column value and display it in seperate column

See more:

SQL

server

Can it is possible to do this in single select statement.


for Example

CREATE TABLE dbo.Table1 
(
    Col1        CHAR(1),
    Col2        CHAR(1),
    Col3        CHAR(1),
    Col4        VARCHAR(50)
)
GO


INSERT INTO dbo.Table1 VALUES ('A','B','C','100,28784,3'),('C','D','E','200,30,400,8999')
GO

SELECT * FROM dbo.Table1;
GO

Output should like this...It should be in single select statement.

Col1 Col2 Col3 Val1  VAl2   Val3  Val4  Val5
A    B     C    100  28784  3     null  null
C    D     E    200  30     400   8999  null