Hello,

I have a dataTable in my database with columns title, category,
problem(description of the problem) and solution. I want to develop a good
search mechanism for certain problems so that the user can search for
problems – solutions, when he quotes a search term. But I think it is not a
good search mechanism when the specific problem with solution is only
displayed when the user quotes the correct title of the problem. Is there any
other possibility, which is not so difficult to implement?

Regards
mat

I think I can make it with Full Text Search. Does anbody know how the SQL
Query String should look like, when I want to retrieve all titles of the
dataTable when the quoted search term occurs in the title or the problem
description or the solution?

As said my columns are
Title
Category
Problem
Solution

But I have SQL Server 2000 and there is no menu point for enable Full Text

I have just read that the SQL Server CE does not support Full Text Search.

[quoted text, click to view]

Here are many exmples of FT queries:
http://www.winnetmag.com/Article/ArticleID/8967/8967.html.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

[quoted text, click to view]

Unfotunately you should create your own solution, maybe using LIKE operator.
You could try to post tis question in the .CE group before giving up.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com