Link to home
Start Free TrialLog in
Avatar of toni_
toni_Flag for Canada

asked on

Split SQL column into multiple columns-delimited by a space

Hi,

I have the following table structure.

Table 1
RowID(PK)
Definition

Here is some sample values
1         2593 j3953 sf8439432 xdfgs94
2         32x d24 x63s4

I would like to get a query that will return me the following columns

1         2593 j3953 sf8439432 xdfgs94      2593      j3953       sf8439432          xdfgs94
2         32x d24 x63s4                                32x        d24          x63s4

Thanks,
Tony
SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of toni_

ASKER

Wow great!  Exactly what i was looking for, thanks alot
You are welcome. It was a very interesting question.