Post reply

Help on full text search

  • April 17, 2007 at 8:06 am

    #116915

    Hello,

    Does SQL2000's full text search support the following: (presumably yes)

    I have a table with a "Subject" field that has been indexed.

    There is a record with "Subject" contains: "test 123"

    How can I get that record?

    Why the following query doesn't work?

    set @text = char(34) + 'test 123' + char(34)

    Select * From TableName

    Where  Contains(Subject, @text)

    Thanks.

  • April 17, 2007 at 8:19 am

    #700927

    Sorry, it works. It didn't work probablly because the record was just revised and the index was not updated.

     

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

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