full-text catalog index CONTAINS() doesn't work with numbers

Question

I've just moved databases from one server to another, this query works fine on the old server but now it doesn't work on the new one when I use numbers only in the search:

SELECT *
FROM Products
WHERE  CONTAINS(ProductTitle,'"sample*" AND "7*"') 

When you remove the 7* it works fine on the new server but it doesn't return anything with it included. Just tested the same exact query on the old server and it runs perfectly fine.

Answer 1

try to use 'like' instead 'CONTAINS'

Answer 2

In case someone else ran into this... the new server I moved to had a "stoplist" which for the full-text catalog was for any single letter. I removed it and everything worked.