I have a varchar (40) field in a table that I would like to split. The delimiter is a space.
It currently looks like this --- > datax datay
I want the end result to be a select statement that splits the field into two fields. What is the best way to do this? Note: what is in datax and datay is not constant meaning it could have different character lengths. I don't see in sql the equivilent of split in visual basic.
Any help would be appreciated.