I have a question, I'm in the process of making a query against this using
fulltestsqlquery: SELECT Title, Path, Size, summarytext, fileextension,created FROM SCOPE() WHERE (SearchField = 'test' OR SearchField LIKE '%; test;%' OR SearchField LIKE 'test;%')
that returns documents where the field value is something like "test; test1; test1;", or "test" but the following will not return any matches: "test1; test; test1;" or "test1; test1; test;" the middle part of my query should cater for that: SearchField LIKE '%; test;%' but it doesn't, does anyone have any idea why?
Replacing the middle of the query with
CONTAINS(SearchField, '"; Test;"') only matches the word in the search term, it doesn't include the semi colons and therefor returns the test1 items
is there anything i could do to modify the query to include contents in the middle and end of the delimited string?