I'm using LOBase 5.0.5.2 to browse an ODBC database. One string column
contains "?" (a single question mark) for many of its entries. If I click
on a ? cell and click AutoFilter, everything works fine. But if I click
Standard Filter and set the criteria to match <column name> = "?", I get no
results. Weirdly, if my criteria is <column name> LIKE "?", then every row
is returned. It's as if LOBase is treating ? as a wildcard. However, I
can't figure out how to escape it in the query form.
How can I search for a field that contains a single "?" ? Any help would
be appreciated.
-Alan