SQL Query Using Full Text Engine inSQL 2005

[Phanikumar.J]

Hello
I need help regarding a SQL Query
We are designing a job site, and there is a job search. In this search
There is a textbox for entering the keywords or any string for the search.
After the Search button click I should give results of the string in a data grid.
But I had doubt in SQL Query. Here I am using Full text engine in SQL 2005. And the queries are FREETEXTTABLE and COTAINSTABLE.
The rank differs for both.
Example:
Enter Keywords : I want job in c ,vb company is Microsoft.
FREETEXTABLE QUERY:

Select * From jobposting as posting Innerjoin Freetextable (jobposting,*,'"*I*" | "*want*" | "*job*" | "*in*" | "*.net*" | "*vb*" | "*company*" | "*is*" | "*microsoft*" ') as frees ON trees. [Key]=posting. [ID] order by Rank Desc








CONTAINSTABLE QUERY:

Select * From jobposting as posting Innerjoin Containstable (jobposting,*,'"*I*" | "*want*" | "*job*" | "*in*" | "*.net*" | "*vb*" | "*company*" | "*is*" | "*microsoft*" ') as frees ON trees. [Key]=posting. [ID] order by Rank Desc



Suggest me the appropriate query for my search,

Thanking You,
Phani.

[platha]

Hi, Search with every word in each and details table, because the format may not be in the same order. we cant find the primary id, search with every word once by esuming each and every as the Id.