Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Searching engine (using MSDE)

Author  Topic 

SQLError
Yak Posting Veteran

63 Posts

Posted - 2005-02-17 : 20:58:51
Hi, I have a field in my table which contains text.

Can someone give me factual pointers on how to do a search for key words within that column. I just need pointers and I can do the rest.
I am using MSDE. Is there a way to index text within that column?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-02-17 : 21:00:34
This should help:

http://www.sqlteam.com/item.asp?ItemID=5857

I don't know if MSDE supports full-text indexing, but I doubt it does. The technique in the above link will still work though.
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-18 : 08:44:20
MSDE doesn't support full text.

Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -