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 |
|
latingntlman
Yak Posting Veteran
96 Posts |
 Posted - 2008-03-19 : 14:41:11
|
| I've got a field with first and last names together. I need to break it into two separate fields. One with first name; the other with last name.How can I best do this?thx,John |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2008-03-19 : 14:50:13
|
| Search for fnParseString on this forum. You should read through some of the threads since there are many caveats to parsing names. E.g., how would you handle Oscar De La Hoya?Jim |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-03-19 : 15:59:33
|
Oscar De La Hoya! Perfect. We now have the definitive "Why Parsing First/Last Names Is Not As Easy As You Think" example.  - Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
latingntlman
Yak Posting Veteran
96 Posts |
Posted - 2008-03-19 : 16:17:42
|
| Thank you fellas,I'll check them out and let you all know...John |
|
|
|
|
|
|
Need to break First Name; Last Name