We have few 100 items within a SharePoint List. We use SSE for indexing this list. We try to implement some kind of wildcard functionality by using the SSE Search WebService. http://<server>/_vti_bin/search.asmx. We get some results but somehow they are unpredictable.
For Example:
We have the following data
1 2009 cb1fc11bc79d - 12-10- 2009
2 UNITTEST - 12-10-2009
3 Lorem Ipsum, Lorem met Ipsum Dolar - Related to xxx
4 Related to xxx - Lorem Ipsum, Lorem met Ipsum Dolar
Searched for: like '%2009%'
Row 1 is returned
Searched for: like '%met%'
Row 3 is returned
We use this query (simplified) to search.
<QueryText type="MSSQLFT" language="en-us">select title from scope() where title like '%met%'
</QueryText>
We miss row 2 and 4, while they contain the exact same data only in a different sequence.
Can someone please help?
Thanks
Rene