Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    3

    Unanswered: No records returned using contains keyword

    Hi,

    This is my 1st thread. Hopefully somebody can help me with the full-text serach.

    I enabled full text serach on sql server 2k and created a catalog for a table
    I tried using the following sql statement but it doesn't seem to return any records although I used a like statement and got some records. Can anybody answer why this is so? Thanks!

    Select * from table1 where contains (field1, '"ESTATE PLAN"')

    Regards,
    Ronald

  2. #2
    Join Date
    Mar 2005
    Posts
    3
    Anyone can help? Thanks.

  3. #3
    Join Date
    Jun 2003
    Posts
    269
    have u tried without double quotes, as shown below?
    Select * from table1 where contains (field1, 'ESTATE PLAN')
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  4. #4
    Join Date
    Mar 2005
    Posts
    3
    I tried without using the double quotes but it returns me the following syntax error.

    Syntax error occurred near 'PLAN'. Expected ''''' in search condition 'ESTATE PLAN'.

    I tried just searching for the keyword 'ESTATE' using the single quotes but no records returned.

    What could be wrong?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •