InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 15:56:03 GMT20http://www.sqlservercentral.com/Forums/Topic1414832-360-1.aspxHi Ivan Mohapatra,I tried in Where Condition It self..Thanks,Mon, 11 Feb 2013 12:47:44 GMTsuresh0534http://www.sqlservercentral.com/Forums/Topic1414832-360-1.aspxDude try like in the where conditionMon, 11 Feb 2013 05:50:50 GMTIvan Mohapatrahttp://www.sqlservercentral.com/Forums/Topic1414832-360-1.aspxI have one table in sql server say example Table Name: candidatesTest table contains some columnscid , cname,c_resume these are the columnscid 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,Fri, 01 Feb 2013 13:12:58 GMTsuresh0534