Syntax Error Near '&&<term&&>' In The Full-text Search Condition '&&<term&&> &&<term&&> &&<term&&>'.

Hello,



Although this SP intends to sorround a search text in double quotes, it seems that when called from Management Studio it throws a Syntax Error even before entering the SP.



createproc fts(@t nvarchar(1000)=null) as begin

select @t = '"' + @t + '"'

select @t

select * from dbo.products where CONTAINS(name, @t)

end



GO



exec fts @t = 'my product name'



GO



Msg 7630, Level 15, State 3, Procedure fts, Line 4

Syntax error near 'product' in the full-text search condition 'my product name'.



-------------------------



If I pass the string in double quotes I get a different error:

exec fts @t = '"my product name"'

Go



Msg 7630, Level 15, State 3, Procedure fts, Line 4

Syntax error near 'my' in the full-text search condition '""my product name""'.



Now, if I remove the quotes again and make the original call:



exec fts @t = 'my product name'

GO



-- Then it works fine.



Doing a :

dbcc freeproccache

GO



Shows the same behavior as outlined initially.