Page 1 of 1

Within search on wildcards

Posted: Fri May 10, 2002 5:47 pm
by skalyanaraman
Hi,
We are trying to do the following search,

select * from tbldoc where OCR like 'w/2000 meeting "board of director*"'
and the hit we want is not there. But when we see the record we see meeting and the phrase board of directors within 1600 characters.
Why is it so? But when I try to do,
select * from tbldoc where OCR like 'w/2000 meeting "board of"'
the document we want is found. It seems the wildcard is throwing it off.

Any ideas on how to fix this search to run properly?
thanks

Within search on wildcards

Posted: Mon May 13, 2002 5:32 pm
by mark
Actually it appears to be a problem with wildcards on the end of a phrase. We'll have to look into a fix.

Normal suffix processing will find things like that without needing a wildcard.
like 'w/2000 meeting "board of director"'