var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Return matched words
When using containstable or freetexttable, how do you return the words that were matched in a separate field?
Here's what I have so far:
select book,chapter,verse,body from
containstable(b_bbe,body,'"Jesus said to him"') S, b_bbe B
WHERE (S.[KEY] = B.ID) and rank<>0
order by rank
This returns :
body: But Jesus made answer, saying to him, ...
What I need it to return is:
body:But Jesus made answer, saying to him, ...
I don't know if this is possible, but any help would be greatly appreciated.