SQL Query Using Full Text Engine inSQL 2005

[Phanikumar]

Hello Freinds,

 

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.