You might want to take a look at InstantDoc #21071 titled "Treat Yourself to
Fn_Split()" on the SQL Magazine site.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=21071 
This article describes a UDF that you could use to easily split your stings.

-----Original Message-----
From: speedguru@m... [mailto:speedguru@m...]
Sent: Saturday, December 01, 2001 7:59 AM
To: sql language
Subject: [sql_language] split string & insert


hi,

i've got a table that looks like this -
table 1 :

id          keyword
--    --------------------
1    mary had a little lamb
2    hope floats
..    .............................

now i want to put this info into  a new table  this way -
table 2 :

id    keyword
--    --------------------
1    mary
1   had
1   a
1   little
1   lamb
2   hope
2   floats
..    .............................

i was wondering if this  can be achieved using a single query

thanks for your time....

:-)rk






Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks