|
|
Posted by RSummersJr on 10/10/20 11:33
Hello,
I have been placed in charge of migrating an old access based database
over to sql server 7.0. So far, I have imported all the tables into
sql server, but now I have come across the issue of needing to split a
string variable. For instance, in the old database, the variable for
name was such that it included both first and last names, whereas in
the new database there are seperate entities for first and last name.
I know that there is a way to write a script that will separate out the
two strings by using the "space" in between the name, but I'm
unfamiliar how to do this. Any suggestions? Thanks!
Rick
Navigation:
[Reply to this message]
|