SQL Server CONTAINS ignores single quote before asterix [closed]

Question

Let's say I have table NamesTable, which has text index on Name column

DECLARE @String2 NVARCHAR(20) = '"SomeName''*"'
SELECT * FROM NamesTable
WHERE CONTAINS(Name, @String2)

What does single quote in CONTAINS string mean? Why is it ignored?

Answer 1

CONTAINS is used for full-text searching, and can search for:

• for a word or phrase
• the prefix of a word or phrase
• a word near another word
• a word inflectionally generated from another word, such as spoon and spooning
• synonyms

Perhaps you should use:

DECLARE @String2 NVARCHAR(20) = '"SomeName''%"';
SELECT * 
FROM dbo.NamesTable NT
WHERE NT.Name LIKE @String2;