How to create a full text search in DB.

Hi everibody.

My name is Ivan and I am from Slovakia.

I would like to ask you all for helping me in creating a full text search in database.

I am working in Visual Web Developer 2005.

I have a simple table in wich i have this atributes: ID, NAME, DESCRIPTION, CONTENT

I would like to use the search for this:

When I write down for example a NAME to a textarea (whatever else it can be), I need to get back the information about the ID of the apropriate NAME.

I would really appreciate your help here.

Please can you send me a mail with the solution or any help on ivoporsche@.szm.sk

Thank you very much in advance.

Try the link below for a tutorial on Full text search in SQL Server. Hope this helps.

http://www.databasejournal.com/features/mssql/article.php/3454281