Post reply

Problem with FULLTEXT Search (CONTAINS)

  • December 11, 2007 at 6:21 am

    #177495

    Hello All

    I am doing FREETEXT search in my Database.

    I have indexed my table (Article_ArticleContent) and included some of the columns.

    However, executing the query do not returns any records:

    SELECT

    cArticleTitle, cShortDescription

    FROM

    Article_ArticleContent

    WHERE CONTAINS

    (cArticleTitle,' "a*" ');

    Although executing the following query, it returns me the correct number of records:

    select cArticleTitle, cShortDescription

    from dbo.Article_ArticleContent

    where cArticleTitle LIKE 'a%'

    Can some1 please let me know if I am missing something in Indexing or in the SELECT query.

    Ankit

  • December 12, 2007 at 3:37 am

    #759323

    I did some testing with fulltext vs like statements ; I think you need to read BOL more carefully as I don't seem to remember the fulltext search working quite like that - as far as I remember you have to think differently with fulltext. I think I found include columns were faster with like statements ( in my case )

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply