mardi 6 janvier 2015

SQL Server CONTAINS ignores single quote before asterix


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?





Aucun commentaire:

Enregistrer un commentaire