I have a column of data that has values such as this (with spaces within):

a1 234
ab12 ddd
a11 12d
s4 9dd

I want to be able to re-select this column of data and split it so that the first part of the data (before the space) is separate from the second part of the data (after the space). So "A1 234" would be "A1" Column1 and "234" Column2, "Ab12 ddd" would be "Ab12" Column1 and "ddd" Column2 etc....

I'm thinking along the lines of using the Left and Substring functions but not sure how best to implement them.

Thanks

ahhh - just worked out my own soln along the lines of:

select left(columnname,charindex(space(1), columnname))
from mytable

...