| proud-collector.com 2006-10-24, 6:37 pm |
|
proud-collector.com wrote:
> I've created a simple search engine for my website that passes the
> search phrase into a stored procedure through a parameter. The
> parameter is parsed and the words are separated and then compared
> using: table1.field1 like '%' + @SearchWord + '%'.
>
> I now want to make the search engine a little more complex, allowing
> people to search with quotes so that any quoted text will be treated as
> a sinle "word" and not separated by spaces. I am trying to find an
> elegant way top pull quoted text (could be multiple sets of quoted
> text) out of the search phrase prior to parsing for space separated
> words.
>
> Can you suggest an elegant way to do this?
>
> Thanks
>
> --
> Web and Article Directory
> http://directory.proud-collector.com/
> Collectibles and Blogs About Collecting
> http://www.proud-collector.com/
No takers on this one?
|