Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Question Unanswered: Full-text of XML data column

    Hi gurus

    A developer created a stored procedure that search in a huge table in a column with ‘like’ statement.
    I know that the best solution in most case is use of full-text.

    But the content of this specific column is a XML data and Full-text don´t find words as desired.

    For example:
    Table content:
    ID = 1
    DsColumn = ´<Name>BETH</Name>´

    select * from tbResp
    where DsColumn like '%BETH %'
    ID DsColumn
    --- ---------------------------------
    1 <Name>BETH</Name>
    1 row(s) affected

    select * from tbResp
    contains(DsColumn, ' BETH ')

    0 row(s) affected

    Can anyone give me a better solution?


  2. #2
    Join Date
    Mar 2003

    Thumbs down

    No Solutions?!

Posting Permissions

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