how to split a coloumn into 5 coloumn

[supermen]

to all, how to split a column into 5 coloumn.
e.g
column= 1 2 1 3 4

into
colomn1 = 1
colomn2 = 2
colomn3 = 1
colomn4 = 3
colomn5 = 4

thanks a lot

[camel]

You could use SUBSTRING

[Delerna]

If there are any numbers in the sequence greater that 9 then
you can use CHARINDEX to find the location of the spaces
for use with substring

[Delerna]

If you need help with charindex then just ask and I will provide an example