Discussion:
Query results not accurate.
(too old to reply)
DavidAtWork
2006-11-17 15:52:02 UTC
Permalink
Hi,
When I try to run a query on indexing service I do not get accurate results.
For example.

Say im trying to find a .pdf file with the following name.... abc1234.pdf
but I don't know the full file name..all I know is... abc123
So I put in a search query... abc123* ... and get no results.
However, if I put in abc1235 I get several results. Like...
abc1233
abc1234
abc1235
abc1236
etc
Why doesn't abc123* work as a query?

Any suggestions?
thanks.--
David
Hilary Cotter
2006-11-25 12:54:17 UTC
Permalink
It does in contains but not in freetext.
--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
Post by DavidAtWork
Hi,
When I try to run a query on indexing service I do not get accurate results.
For example.
Say im trying to find a .pdf file with the following name.... abc1234.pdf
but I don't know the full file name..all I know is... abc123
So I put in a search query... abc123* ... and get no results.
However, if I put in abc1235 I get several results. Like...
abc1233
abc1234
abc1235
abc1236
etc
Why doesn't abc123* work as a query?
Any suggestions?
thanks.--
David
DavidAtWork
2006-11-27 18:40:02 UTC
Permalink
Hi Hilary,
Can you elaborate on your last comment?
Please and thanks...
--
David
Post by Hilary Cotter
It does in contains but not in freetext.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
Post by DavidAtWork
Hi,
When I try to run a query on indexing service I do not get accurate results.
For example.
Say im trying to find a .pdf file with the following name.... abc1234.pdf
but I don't know the full file name..all I know is... abc123
So I put in a search query... abc123* ... and get no results.
However, if I put in abc1235 I get several results. Like...
abc1233
abc1234
abc1235
abc1236
etc
Why doesn't abc123* work as a query?
Any suggestions?
thanks.--
David
Loading...