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 Kumar C ------------------------------------------------------ MCITP - Database Administration SQL SERVER 2008 MCTS - Database Development SQL SERVER 2008
charindex
Posted - 10/08/2012 : 05:06:16
