0

I'm looking for a good method to split a string based on space\underscore into one columns.

For example:

string name = 'tom arnold lee ford'
into named_columns

and then do a query:

select name from named_columns

Output:

tom
arnold
lee
ford

Thank you...

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Aviad Amar
  • 13
  • 1
  • 4
  • Possible duplicate of [Turning a Comma Separated string into individual rows](https://stackoverflow.com/questions/5493510/turning-a-comma-separated-string-into-individual-rows) – juergen d Dec 15 '17 at 19:12
  • How is it help me? Dont understand – Aviad Amar Dec 16 '17 at 07:04
  • It is the same principle. You have space as sepratator. The question linked uses commas. But the rest is the same. – juergen d Dec 16 '17 at 09:52

0 Answers0