2012年3月25日星期日

Full Text search in SQL Server 2005 Express?

Newbie questions.

1. Can SQL Server 20005 Express do full text searches?

2. If not, is there a way to use SQL Server 20005 Express to search a database column containing text data type?

Using Visual Basic 2005 Express, I would like to do a simple search with a search textbox and button that will return the entire contents of a field of database text when one or more words in the search text box are in the field of text in the database.

I have been playing in Visual Basic 2005 Express and using SQL queries (SELECT, FROM, WHERE) to output to DataGridView controls by using ID columns as filters in the query, etc. This I can do. But I have not been able to use a word or phrase in the search textbox as a filtered query to output the entire database field of text which contains the search word or phrase in the search textbox.

Thanks for any help in getting me started with this.

SQL express with advanced services offers full text search. Take a look at the FreeText sql statement for full text searches.|||

Thanks Ken.

I will get the Advanced Services version of SQL Express and work on learning to use the full text search feature.

sql

没有评论:

发表评论