Query for taking each word in a string, and putting a comma after it?

Hey all, i'm making the pages meta keywords on my site dynamic, and i was wondering is there is a string, for example "Dell 17" Monitor Brand New", that would split it into each word for the meta keywords. example "Dell, 17", Monitor, Brand, New" (and possibly to not put a comma on the last word?)

update myTable
set myField = Replace(myField, ' ', ' ,')

This will replace each space in your string and replace the space with a space + a comma.

I do the same thing (allowing for dynamic meta data) in my sites. However, I keep each word or phrase as a separate record in my db.
Then when I query for them I save them into an array and print array[0] + ", " array[1] + " ,"...

If you need to keep your data in it's original state than I suggest creating a temp table and modifying the temp table.

sql

Query Analyzer: Keyword color schema.

Hello,
Are there any information about Whick keywords is colored by Query Analyzer
?
I want to create keyword schema file for IMHO Instant blogger's Code Snippet
Editor.
Books Online's reserved keywords is not enouph.
For example: @.@.error, any sysobjects, etc.
Regards,
Yoshihiro Kawabata
MVP for SQL Server
PASSJ board-leader.
Yoshihiro Kawabata wrote:
> Hello,
> Are there any information about Whick keywords is colored by Query
> Analyzer ?
> I want to create keyword schema file for IMHO Instant blogger's Code
> Snippet Editor.
> Books Online's reserved keywords is not enouph.
> For example: @.@.error, any sysobjects, etc.
> Regards,
> Yoshihiro Kawabata
> MVP for SQL Server
> PASSJ board-leader.
Have a look at the SQL Server 2000 Syntax File for TextPad here:
http://www.textpad.com/add-ons/synn2t.html
Scroll to the item called:
SQL (Transact) TextPad syntax definitions for Transact SQL.
Complete list of keywords for MSSQL2000 SP3a.
Contributed by Alexander Mitelman, 17 August 2004.
You don't need TextPad to view the file. It may give you a good start.
David Gugick
Imceda Software
www.imceda.com
|||Hello, David.
Thank you for quick response.
It's a very nice.
I will feed back to IMHO team.
Best regards,
Yoshihiro Kawabata
MVP for SQL Server.
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OAZog83KFHA.3076@.tk2msftngp13.phx.gbl...
> Yoshihiro Kawabata wrote:
> Have a look at the SQL Server 2000 Syntax File for TextPad here:
> http://www.textpad.com/add-ons/synn2t.html
> Scroll to the item called:
> SQL (Transact) TextPad syntax definitions for Transact SQL. Complete
> list of keywords for MSSQL2000 SP3a.
> Contributed by Alexander Mitelman, 17 August 2004.
>
> You don't need TextPad to view the file. It may give you a good start.
> --
> David Gugick
> Imceda Software
> www.imceda.com