toni_
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome. It was a very interesting question.
ASKER