Search problem with V4RB4.8.1

[jda]

Hi Ruslan,

This search used to work with version 4.7

select 
id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMethod,thedateSortMethod 
from thereferences where RecID in (1) AND (left([allFields], 5) = 
'adams') AND (left([allFields], 1) = 'm') ORDER BY 
authorsSortMethod,thedateSortMethod

Now it does not.

This search *does* work

select 
id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMethod,thedateSortMethod 
from thereferences where RecID in (1) AND (left([allFields], 5) = 
'adams') ORDER BY authorsSortMethod,thedateSortMethod

and so does

select 
id,hit,uniqueID,varCharField,[authors],[thedate],[title],editors,authorsSortMethod,thedateSortMethod 
from thereferences where (left([allFields], 5) = 'adams') AND 
(left([allFields], 1) = 'm') ORDER BY 
authorsSortMethod,thedateSortMethod


I see nothing wrong with the first search. Did something change 
between 4.7 and 4.8 that should affect this?

Jon