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