We're running a search that looks like this:
tsql "select ID from mytable where myID = '1234' and myDescription like 'CASE LOAD ALPHA -xyzz 12'"
We get zero hits returned. If, however, you look at the record with ID 1234 you see this in the myDescription field:
CASE LOAD ALPHA CLIENT, STATUTE FGEN 12 DATE
And if we run the same search as above but without the -xyzz portion we return a hit.
Essentially, *any* search we run with the exclude (-) operator gives us zero hits, and we can't figure out why. I thought maybe our index didn't have this record in it, though it should. Do you have any notions what may be happening, and how can I check to see if our 'myDescription' index has this particular document in it?
tsql "select ID from mytable where myID = '1234' and myDescription like 'CASE LOAD ALPHA -xyzz 12'"
We get zero hits returned. If, however, you look at the record with ID 1234 you see this in the myDescription field:
CASE LOAD ALPHA CLIENT, STATUTE FGEN 12 DATE
And if we run the same search as above but without the -xyzz portion we return a hit.
Essentially, *any* search we run with the exclude (-) operator gives us zero hits, and we can't figure out why. I thought maybe our index didn't have this record in it, though it should. Do you have any notions what may be happening, and how can I check to see if our 'myDescription' index has this particular document in it?
