Ex.
Column 1:
| word1 word2 word3 word4 |
to
Col 1: Col 2: Col 3: Col 4:
| word1 | word2 | word3 | word |
Is it possible to separate different words or phrases from a string into multiple columns? All words and phrases in the strings are usually separated by double spaces, nothing else. Is there a pre-defined function I can use already available from SQL Server like CAST or INTERSECT, or do I have to write my own?
See Question&Answers more detail:os