need out put in sqlserver

My table:-

id Name

1 abc
2 name:abc
3 name : abc emp:001

I need output loke in sql server.

id Name

1 abc
2 abc
3 abc
...