|
If you hover your mouse cursor over the checkbox "Inter-Book Search", a large yellow tooltips-box will open. It explains how to use "Inter-Book Search", including the "Required Settings".
See the attached image of the tooltips. Note "REQUIRED SETTINGS" item "[3]": 'AND' must be selected in the Middle Column.
By design, MCS automatically 'jumps back' to 'AND' plus the other required settings whenever you attempt to use "Inter-Book Search". It doesn't tell you that you disregarded the explicit tooltips instructions; it just corrects your mistakes and continues with the search.
MCS can use regular expressions to do 'fuzzy searches', but only for 'Intra-Book' Searches.
MCS 'Inter-Book' Searches only use the '=' operator, as indicated in the yellow tooltips. The comparison is done implicitly, not explicitly, entirely within SQL using a collating sequence of "exact match, not case insensitive".
MCS 'Inter-Book' Searches are an entirely different animal than 'Intra-Book' Searches.
DaltonST
|