SQL Server ContainsTable finds no partial matches

I am trying to use ContainsTable to return a ranked list of results.

It works fine for me when it finds an entire phrase, but its not seems to work for partial words. For example, if I search for "acq" it will not find "Acquisitions". I really need it to work with partial matches for this to be useful. Using "Like" is not an option as the results need to be weighed.

SELECT
    TitleRanks.RANK,
    CourseId,
    CourseTitle         
FROM
    TBL_LMS_CLIENT_COURSES as Courses
    INNER JOIN CONTAINSTABLE(Courses,CourseTitle,'acq') AS TitleRanks 
        ON Courses.CourseId = TitleRanks.[key]      

      

Any ideas would be great.

thank

+2


source to share


1 answer


Does the script prevent the use of a prefix term in the contains clause?



 INNER JOIN CONTAINSTABLE(Courses,CourseTitle,'"acq*"') 

      

+5


source







All Articles