Full Text Search (2005) - How to determine word offset in CONTAINS query?
Does anyone know if it is possible to determine the relative word offset (the Occ) from a simple-term query such as:-
SELECT Comments
FROM Production.ProductReview
WHERE CONTAINS(Comments, ' "mountain biking" ');
So, given the text:-
"Maybe it's just because I'm new to mountain biking, but I had a terrible time getting used to these pedals."
I would like the query would return both the text and the word offset of 8.To me, it seems like this would be quite useful as I want to highlight the found text for the user to see. Obviously I can do a post-SELECT scan of the string to find the values but this would seem unnecessary.
If anyone can give me any pointers I'd be very grateful.
Thanks

