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: 559

Filed under:

contains

|

fulltext-search

|

full-text-indexing

|

sql

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

Sorting List which has object that contains two string members that contains numbers

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to know the best solution for this my case here is that i am taking values from Excel sheet and pushing them to database field, sometimes that field might contain some strings (thats why I cant make my object members int / double) In my class below size is the variable responsible for showing… >>> More
Testing if a list contains another list with Python

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I test if a list contains another list. Say there was a function called contains: contains([1,2], [-1, 0, 1, 2]) # Returns [2, 3] (contains returns [start, end]) contains([1,3], [-1, 0, 1, 2]) # Returns False contains([1, 2], [[1, 2], 3) # Returns False contains([[1, 2]], [[1, 2], 3]) # Returns… >>> More
Full Text Index Queries using CONTAINS and CONTAINSTABLE

as seen on Internet.com - Search for 'Internet.com'
Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on the remaining two constructs, CONTAINS and CONTAINSTABLE. >>> More
Search in a List<DataRow>?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a List which I create from a DataTabe which only has one column in it. Lets say the column is called MyColumn. Each element in the list is an object array containing my columns, in this case, only one (MyColumn). Whats the most elegant way to check if that object array contains a certain… >>> More
nhibernate activerecord linq Contains problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am having problems with the following query in Castle ActiveRecord 2.12: var q = from o in SodisceFMClientVAR.Queryable where taxnos2.Contains(o.TaxFileNo) select o; taxNos2 is an array of strings. When run I get an exception: + InnerException {"Index was out of… >>> More

Related posts about fulltext-search

PHP: How to use mysql fulltext search and handle fulltext search result

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have tried to use mysql fulltext search in my intranet. I wanted to use it to search in multiple tables, and get the independant results depending on tables in the result page. This is what i did for searching. $query = " SELECT * FROM testtable t1, testtable2 t2, testtable3… >>> More
What is the big difference between Fulltext-Search on SQL2000 and SQL2008

as seen on Server Fault - Search for 'Server Fault'
Hi, my first test to get a given database with activated fulltextsearch running on a sql2008 failed with the result that it creeps. sql2008 took several the time of sql2000, but why? >>> More
FullText Search using multiple tables in SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there. I have 3 tables, tblBook(BookID, ISBN, Title, Summary) tblAuthor(AuthorID, FullName) tblBookAuthor(BookAuthorID, BookID, AuthorID) tblBookAuthor allows for a single book to have multiple authors and an author may have written any number of books. I am using full text search to search… >>> More
Fulltext search on many tables

as seen on Stack Overflow - Search for 'Stack Overflow'
I have three tables, all of which have a column with a fulltext index. The user will enter search terms into a single text box, and then all three tables will be searched. This is better explained with an example: documents doc_id name FULLTEXT table2 id doc_id a_field FULLTEXT table3 … >>> More
Hibernate Search Paging + FullTextSearch + Criteria

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to do a search with some criteria FullTextQuery fullTextQuery = fullTextSession.createFullTextQuery(finalQuery, KnowledgeBaseSolution.class).setCriteriaQuery(criteria); and then page it //Gives me around 700 results result.setResultCount(fullTextQuery.getResultSize()); //Some pages… >>> More