views:

160

answers:

0

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]