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 |
|
waxdart23
Starting Member
33 Posts |
 Posted - 2005-11-28 : 08:26:37
|
| I have a customer name field which I need to convert into a new system that has the names sepeated into title, first name and last name. I can get the title by using:left(rinfo_1, (patindex('% %', rinfo_1) - 1))but cannot work out how to get the rest as they are variable length so cannnot use 'Right'.Please can anyone help?ThanksThanksP |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-11-28 : 08:36:02
|
| Post some sample data and let us know the required output.Surendra |
 |
|
|
waxdart23
Starting Member
33 Posts |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
|
|
|
|
|
seperating out name fields