Thanks for Reply, but it will not work for me. I want same behaviour from freetext serach using freetext or contains predicate, just like '%isual%', the syntaxt you provided will failed for me, For Example: let say have table name "table1" having one column "Col1" and table has these values visual C# C++ Adobe Photshop SQL Server Basic Language MY SQL HR Questions MBA (Marketing) Here is variable in Store Procedure: ------------------- DECLARE @KEYWORD NVARCHAR(MAX) SET @KEYWORD ='Visual'; SELECT * FROM TBALE 1 WHERE Contains(Col1,@KEYWORD) IT WILL RETURN ME Only one Row Visual -------------------- SET @KEYWORD ="visu"; SELECT * FROM TBALE 1 WHERE Contains(Col1,@KEYWORD) if i use this change the variale value to "visu" it wil return me no row --------------------------- SET @KEYWORD ="sual C#" ; SELECT * FROM TBALE 1 WHERE Contains(Col1,@KEYWORD) and if i again change value of vairable to "sual C#" then again no result. ----------------------------- I want result in these two cases,is the possible. Again THANKS IN ADVANCE Many Thanks, adnan
Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com