I have a table with products. In this table there is a column with some information about the product, like product name, number, etc..
CR1AC1EM1SP10535PG5 008498 31755 008498 4015080317555 My product
The bold part is the number that I want to search for using the ContainsTable keyword. My query look like this:
SELECT top 10 * FROM MyTable INNER JOIN containstable(MyTable, ColumnProductInfo, '"4015080317555"', 1000) FTS ON MyTable.ColumnUniqueKey = FTS.[key]
When I run this query it doesn't only return the product with number 4015080317555, but it returns all products of which the product number start with 401508 (the first 6 digits).
The fulltext column has the Neutral language. When I change the language to English and rebuild the index, it returns only product 4015080317555 which is correct. This is what I would expect with the Neutral language as well. I don't like to use the English language since the product names are in Dutch, but both the Neutral as the Dutch language don't work correctly.
When I change the query so that I put an * in place of the last 5 in the product number, then I do get the correct result:
SELECT top 10 * FROM MyTable INNER JOIN containstable(MyTable, ColumnProductInfo, '"401508031755*"', 1000) FTS ON MyTable.ColumnUniqueKey = FTS.[key]
I prefer do use the Dutch (or Neutral) language, because I don't know what other problems I could run into if I change to English (the database already runs at customers).
What is going wrong and what can I do to make this query work for the Dutch or Neutral language?
Any help is greatly appreciated.