Error querying Full-Text Catalog

  • I have the following Full-Text Query:

    SELECT ticket_id,ticketnote_id,ticketNote_text FROM dms_ticketnotes WITH (NOLOCK)

    WHERE CONTAINS (ticketnote_text, ' "*Test0099887766*" ')

    Order by Ticketnote_id

    This returns a single record which I expect.

    Yet, when I run the following:

    SELECT ticket_id,ticketnote_id,ticketNote_text FROM dms_ticketnotes WITH (NOLOCK)

    WHERE CONTAINS (ticketnote_text, ' "*0099887766*" ')

    Order by Ticketnote_id

    I get nothing back. Any ideas?

    Warm Regards,

    Arthur Lorenzini
    Sioux Falls, SD

  • Art,

    You could insert a wildcard character % into the query like such:

    SELECT ticket_id,ticketnote_id,ticketNote_text FROM dms_ticketnotes WITH (NOLOCK)

    WHERE CONTAINS (ticketnote_text, ' "*%0099887766*" ')

    Order by Ticketnote_id

    This should return what you are looking for.

    Mike S

    --Mike

  • Tried the following:

    SELECT ticket_id,ticketnote_id,ticketNote_text FROM dms_ticketnotes WITH (NOLOCK)

    WHERE Freetext(*, '"*%009988"')

    Order by Ticketnote_id

    Still no records.

    Warm Regards,

    Arthur Lorenzini
    Sioux Falls, SD

  • Any other ideas? I even dropped the catalog and re-created it and it still doing the same thing.

    Warm Regards,

    Arthur Lorenzini
    Sioux Falls, SD

  • Is it because I am trying to search for a string of numbers with a wild card?

    eg. SELECT ticket_id,ticketnote_id ticketnote_byname, Ticketnote_text FROM DMS_TICKETNOTES

    WHERE CONTAINS(TicketNote_Text, '"*998877*" ')

    This is the string I am trying to find:

    test00998877665544332211

    Warm Regards,

    Arthur Lorenzini
    Sioux Falls, SD

  • Art,

    You could try this:

    SELECT ticket_id,ticketnote_id, ticketnote_byname, Ticketnote_text FROM DMS_TICKETNOTES

    WHERE Ticketnote_text LIKE '%998877%'

    It's just a simple query that should return the values you are looking for from any row that contains any text that looks like 998877

    I'm not sure if the problem stems from trying to search for a string of numbers.

    I hope this helps,

    Mike S

    --Mike

Viewing 6 posts - 1 through 5 (of 5 total)

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