srinivas P

srinivas P

  • NA
  • 168
  • 189.8k

How to split single row into multiple rows if row have spaces?

Sep 2 2011 1:59 AM
hi to all,

I want to split single row into multiple Rows,if row have a space.using sql server.


Ex:in my table i have one field

Name:
Srini Vasa rao

Iwant to show
Name:
srini
Vasa
rao

How?Help me


Answers (6)