Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-10-08 : 05:06:16
|
Hi,tblMain has a field called clients.This field has both the first and last name in it.How can I separate the two into their own columns using sql?May be this is to do with charindex and look for the first space and then take the first part as firstname and the second as lastname?Thanks |
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2012-10-08 : 05:08:09
|
Post some sample data..Senthil Kumar C------------------------------------------------------MCITP - Database Administration SQL SERVER 2008MCTS - Database Development SQL SERVER 2008 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
|
|
|
|