Re: Problems searching xml data using FTS

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Kane (jt-kane_at_comcast.net)
Date: 02/15/05 

Date: Mon, 14 Feb 2005 20:31:56 -0800

Ram,
This is a non-trivial effort and is possible with normal text, but may be
more difficult with text embedded in XML structures. There is no current
documentation on this as this method was developed for a book project and
not public knowledge at this time. If you want we can discuss this offline
and you can email me at jt-kane at Comcast dot net.

Thanks,
John 

-- 
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"RMulay" <RMulay@discussions.microsoft.com> wrote in message
news:44E52EBF-D39A-474F-A894-CFF6948BC56F@microsoft.com...
> John, you have indicated in your post below that searching can be done the
> way I need it, i.e.  "word prefix" ('*fish') as you called it. Can you
> explain to me how this can be acheived in SQL Server 2000 or point me to
the
> documentation for this?
> Thanks,
> Ram
>
> "John Kane" wrote:
>
> > Ram,
> > SQL Server Full-text Search with the MSSearch service does support
> > prefix_term or more specifically a "word suffix", such as "fish*" and
not as
> > a "word prefix" such as "*fish" as it is a word based indexing method
vs.
> > T-SQL LIKE pattern search method. As to why, this is the only supported
> > method, I'm not sure as this has been the design since SQL FTS was first
> > incorporated in SQL Server 7.0 Beta3 in 1998. I suspect that this is
because
> > of how the FT Index (internal to the MSSearch maintained FT Catalog) is
> > built... Note, I didn't say this couldn't be done, just not done with
the
> > MSSearch implemented methods...
> >
> > Hope that helps,
> > John
>

Relevant Pages