At MSDN I read:
< prefix_term >
Specifies a match of words or phrases beginning with the specified
text. Enclose a prefix term in double quotation marks ("") and add an asterisk (*) before the ending quotation mark, so that all text starting with the simple term specified before the asterisk is matched.
Well, that's prefix, if I search "Iran*" it finds "Iranian, Iran, Iraq, etc.".
But I'm looking for postfix term, so if I search "*ran" then I expect to see Iran in results.
How can I do that?
[UPDATE]
I've such term in ArticleContent column:
f5_Iran_three_islands
This query catches it:
Select Code,ArticleContent from Articles Where ArticleContent Like '%Iran%'
But I can't catch this row by this query:
Select Code FROM Articles WHERE CONTAINS(ArticleContent, '"*Iran*"')
[/UPDATE]