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 |
|
clewis99
Starting Member
3 Posts |
 Posted - 2007-03-07 : 17:51:09
|
| I am trying to update a new column in a table with last names. The last names are coming from another column in the same table, but the format that the names are in right now is as follows 'firstNamespacelastname'. how do I separate the lastname portion from this column and update the lastname column with the lastnames I got from the full name field? |
|
|
Fatbug
Starting Member
5 Posts |
Posted - 2007-03-07 : 18:30:39
|
| HiYou need to use substring and charindex. I think a lot of these small problems have been covered before on this site, just do a search of the site for them. |
 |
|
|
|
|
|
Ms access question