November 3, 2008 at 9:50 am
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
November 3, 2008 at 10:48 am
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
November 3, 2008 at 10:53 am
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
November 6, 2008 at 12:22 pm
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
November 6, 2008 at 12:27 pm
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
November 10, 2008 at 9:36 am
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