Hi Everybody,
I have a database contains more than 10000 documents and its full text Indexed.
In that I have a text field called(DOCNUMBER).
Content of the DOCNUMBER would be like this
ZA01-****
ZA02-****
The problem is when I give a search in a view
I am not getting the proper count
Actual count of ZA* = 1500
Query 1)
([DOCNUMBER] contains (ZA*))
Result 780
Query 2)
([DOCNUMBER] contains (ZA00*))
OR ([DOCNUMBER] contains (ZA01*))
OR ([DOCNUMBER] contains (ZA02*))
OR ([DOCNUMBER] contains (ZA03*))
OR ([DOCNUMBER] contains (ZA04*))
OR ([DOCNUMBER] contains (ZA05*))
Result 1500
Why the search is not working when I give ZA* ?
Thanks in Advance
Joseph