Full Text Search

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Full Text Search

Full Text Search

Rate Topic

Display Mode

Topic Options

Author

Message

suresh0534

Posted Friday, February 01, 2013 1:12 PM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 1:55 AM
Points: 28, Visits: 165

I have one table in sql server say example
Table Name: candidates

Test table contains some columns

cid , cname,c_resume these are the columns
cid in Int ,cname is nvarchar(50), c_resume is text Data Type.

I am Storing candidates resume in c_resume text filed.

I have 10000 rows in table.

If i search c++ resume it will showing the result of c++ and also it showing the resume other than c++

if i search c++11 also it giving the results.

if i search c++1 it not showing any results(Zero Results).

I have written Query like this:

select * from candidates WHERE contains(c_resume_text,'C++') -It shwoing c++ and also other than c++ results.

select * from candidates WHERE contains(c_resume_text,'C++11') -It showing results.

select * from candidates WHERE contains(c_resume_text,'C++1') -It showing Zero results.

Why the above 2 and 3rd showing different results?

in c_resume_text filed there is no word c++11 , but we have c++ word.

I am not understanding the above results? why ?what is happening?

Please help me,

How can i sove the problem,

Thanks,

Post #1414832