Re: [SQL] funstions for parsing words

2005-07-19 Thread Tony Wasson
On 7/19/05, John Kopanas <[EMAIL PROTECTED]> wrote: > I have a table called Phrases that holds the text of a phrase. I want > write a query that will return all the words found in all the text of > the Phrases. Like so: > > > Phrases: > > "Hello World" > "Goodbye World" > "I like can

[SQL] funstions for parsing words

2005-07-19 Thread John Kopanas
I have a table called Phrases that holds the text of a phrase. I want write a query that will return all the words found in all the text of the Phrases. Like so: Phrases: "Hello World" "Goodbye World" "I like candy Words (select statement result): "Hello" "World" "Good