May 18, 2009 at 2:59 am
Good morning,
I have here a little problem, i want to run the follow sp
exec ListProce
@Keywords=N'&l'
where the parameter @keywords belongs to the full text, and when i run that appears Syntax error near 'l' in the full-text search condition '&l'....
How can i fix this without make a replace in the sp where "&" for " "
Thanks
May 18, 2009 at 4:50 am
try escaping the special characters. my guess is that the exception is thrown because the "&" is in first position, if somewhere eles it would problably be ignored.
check here if it helps (sorry for the brief answer but i;m in a hurry) :
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1324260,00.html
hope this helps!
May 18, 2009 at 4:52 am
Post the Stored procedure that you are calling as it is difficult to know what the problem is without seeing it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply