Thread: Full Text Search Error For Search With Space

Full Text Search Error For Search With Space

If you try to make a full text search for a phrase having multiple words and space in between you might bump into this type of error.

For example searching for ROCK CENTER might get you this error:

Syntax error near 'CENTER' in the full-text search condition

Solution:
You need to replace the white space with the % wild character. You can do that on your sql code or on your programming code.
An example for doing it on SQL:
Set @searchKey=REPLACE(@searchKey,' ','%');

thanks for ur information..really good