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 - 2001-06-17 : 19:24:06
|
TempleThrobber writes "Here is my simple, little problem.
I have a database of book titles that I need to 'split' into the first five words.
The *simplified* table would looks like:
title --> SQL for Dummies
word1 --> SQL
word2 --> for
word3 --> Dummies
word4 -->
word5 -->
I need to split up the title and insert each word into the corresponding word(i) fields.
There are also words I need to exclude....such as 'the', 'it'.....and so on. In ASP this would be easy, but it needs to be done in SQL Server becuase of size.
SQL Server 2000 / Win NT 4.0 SP 6.0" |
|
|
|
|
|
Split text into multiple columns