By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,726 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

splitting a string

P: n/a
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

Nov 30 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
(RS********@gmail.com) writes:
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!


I suggest that you look up "Functions" in Books Online, and have a look at
the available string functions. String maninpulation is not a strong point
in T-SQL, but there are some functions. Most commonly used for this task
are substring() and charindex().
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 30 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.