Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  full text search

Author  Topic  sagerpl Starting Member 3 Posts Posted - 2009-05-12 : 15:13:46 Hi, I am trying to get fulltext search to work, my goal is to enable users to search for multiple words within one field. Can someone please take a look at my sql statement and see if you can figure out what is wrong. "SELECT * FROM Kalimages WHERE CONTAINS(Keywords," & "'%" & strSearch & "%'" & "OR" & "'%" & strSearch & "%'" & ")" I get the following errormessage when trying to search for multiple words. Syntax error near 'vestlandet%' in the full-text search condition '%golf vestlandet%'.