Search problem with V4RB4.8.1

[jda]

>  > This search used to work with version 4.7
>>
>>  select
>> 
>>id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMe
>>  thod,thedateSortMethod
>>  from thereferences where RecID in (1) AND (left([allFields], 5) =
>>  'adams') AND (left([allFields], 1) = 'm')
>
>How could these conditions
>
>     (left([allFields], 5) = 'adams') AND (left([allFields], 1) = 'm')
>
>be true ??
>

allFields is a method that returns the concatenated contents of all 
text fields. It is indexed by words, so if you have a word "adams" 
and a word beginning with "m", the record should be found. This 
search has worked for years, but appears to be broken in 4.8.1.

Jon