# 2340 Using the LIKE Operator with a Trailing Space and Wildcard Causes Incorrect Results

---

Our users perform a number of searches in some of the tables, based on setting various filters on specific fields.

Take a (simplified) table with a field "DESCR" containing the following values

ALFA 133
ALFA 160
BETA 200
BETA 220
BETA 300

Setting a filter expression DESCR LIKE 'A%', correctly gives a result of 2 records
Filter DESCR LIKE 'BETA%' gives the expected 3 records
Filter DESCR LIKE 'BETA %' (notice the space character) results in 0 (zero) records and
Filter DESCR LIKE 'BETA 2%' again gives the expected 2 records

The same results are given if I use a filter expression in the format DESCR = 'xxx*'.

I have tried to use the filter in a small test-application and using the elevateDB Manager. Results are equal in both cases.