FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Full-Text Search chapter - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on .NET, Sql, ASP.NET, and other crazy shenanigans

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Full-Text Search chapter

I finally set down today and started to outline my full-text search chapter.  After I did a basic outline, I started writing.  I am happy to say that I have filled up four pages today.  I've been working on pulling together background material on how the full-text indexing works in Sql Server and reading through that over the past couple of days.  I've used full-text search in Sql Server for several years, but I didn't know before the past couple of days what I know now.  Wow, this is really useful and has at least doubled my knowledge of Full-Text indexing.

Wally

Comments

Sahil Malik said:

Wally,

Is it possible to do stem word searching via full text indexing? i.e. If I search for "eating", I should also get matches for "eat", "eaten", "eater" etc. etc. ????
# January 9, 2005 11:16 PM

Sahil Malik said:

Bueller .. Bueller ... Bueller !!??
# January 11, 2005 10:38 AM

John Kane said:

Yes, use either FREETEXT or CONTAINS with FORMSOF(INFLECTIONAL), for example:

contains(TextCol,'FORMSOF(INFLECTIONAL, "fly")')

Regards,
John
# January 11, 2005 8:57 PM

Sahil Malik said:

Thanks John and Wally !! :) .. This'll probably work .. I'll test it out !!
# January 11, 2005 9:56 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)