SQL Server CONTAINS with digits gives no results

Posted by dale on Stack Overflow See other posts from Stack Overflow or by dale
Published on 2010-03-25T13:06:19Z Indexed on 2010/03/25 13:13 UTC
Read the original article Hit count: 563

Hi,

I have a database table which is full-text indexed and i use the CONTAINS-function to perform a search-query on it.

When I do:

SELECT * FROM Plants WHERE CONTAINS(Plants.Description, '"Plant*" AND "one*"');

I get back all correct results matching a description with the words "Plant" and "one".

Some plant are named like "Plant 1", "Plant 2" etc. and this is the problem.

When i do this, i get no results:

SELECT * FROM Plants WHERE CONTAINS(Plants.Description, '"Plant*" AND "1*"');

Anyone know why?

© Stack Overflow or respective owner

Related posts about contains

Related posts about fulltext-search