How to split particular column values into rows by using delimiter using sqlserver

Question

Hi to all

how to split particular column values into rows by using delimiter?


Ex:
In a table One column(Name) having Two rows

1)sravan kumar
2)srinivas rao


My requirement is

under column(Name)
i have to display following manner
1)sravan
2)Kumar
3)srinivas
4)rao

help me if you people have any idea regarding this.
any storedprocedure .

Thanks inadvance