breaking down of a string separated by spaces

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

breaking down of a string separated by spaces

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-27 : 09:30:11

msrjb writes "I would like to break down the following string value from FULLNAME field:
FULLNAME:Francis Kb Mathews

Now I would like to have Francis in FirstName, Kb in MiddleName, Mathews in LastName."

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-27 : 09:33:32

you can make use of the split function here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources