I have created a full text index on a text column. I now want to use CONTAINS in my queries. Let´s say that somewhere in a text field called A there exist the words "fulltextindex", "fulltexttable" and "index".
If I want to find the word "fulltextindex" I would type:
SELECT A from MyTable
WHERE CONTAINS(A, 'fulltextindex')
If I would want to find all words starting with "fulltext" I would type
SELECT A from MyTable
WHERE CONTAINS(A, '"fulltext*"')
But suppose I would want to do a full text search for all words ending with "index". How would I type that?
And how would I state a query that returned all occurencies of "text"("fulltextindex" and "fulltexttable")?