Hello, professionals 
We have Sql Server 2000 in our server and it have over 300.000 rows with comma-delimited list of keywords. We use contains -search because LIKE -search is too slow. Database handles picture information. But now we have big problem. This search:
SELECT ID
FROM imagedatabase
WHERE Contains(categories, ' "moss" ')
worked good earlier, but now we add lot of image-information that had photographer´s name in categories -field. Name can be for example "peter moss". How can I make a query that DON´T take "peter moss" to the query when I search just a word "moss"?
With LIKE -query I can write that it should contain "," before the word (all words are delimited by commas) but with faster Contains -search I haven´t make it work. Help!
We have Sql Server 2000 in our server and it have over 300.000 rows with comma-delimited list of keywords. We use contains -search because LIKE -search is too slow. Database handles picture information. But now we have big problem. This search:
SELECT ID
FROM imagedatabase
WHERE Contains(categories, ' "moss" ')
worked good earlier, but now we add lot of image-information that had photographer´s name in categories -field. Name can be for example "peter moss". How can I make a query that DON´T take "peter moss" to the query when I search just a word "moss"?
With LIKE -query I can write that it should contain "," before the word (all words are delimited by commas) but with faster Contains -search I haven´t make it work
. Help!