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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-16 : 13:18:48
|
Matt writes "I've inherited a project from a small company who was keeping all their customer data in a small desktop database. I've successfully imported it all into SQL 7.
Now for my problem... In the customer contact table, each customer's entire name (first and last) is stored in only one field (Name). Even worse, they are listed First Name then Last Name, and in many cases a "M/M" or "Dr." precedes the first name... (example Name = "M/M John Smith")
I need to be able to sort these out into separate fields as they will eventually have to be sorted by last name. I know that I could loop through them in VB or ASP, but this has to be a semi common occurence and cureable with a savy query? Any help would be appreciated.
SQL Server 7.0 (no service packs)
Windows 2000 Advanced Server (no service packs)" |
|
|
|
|
|
Dividing a record into 2 fields