disabling wildcard in AR reports

Is there a way to disable wildcard searching on
customer name?
I have a few customers setup as: "customer1"
"customer2" ... "customer100"
I am trying to show the aging report for "customer1"
but I keep getting info for "customer10" "customer11"
customer12" ...

the query being sent to postgres is something like:
select * 
from customer 
where lower(vc.name) LIKE '%customer1%'

Why is the wildcard being added automatically?
according to the manual, one has to request it with
the '%' or '_' sign?

notice: I cannot change the customer name format
because it is being used as a keyname in other
applications


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


_______________________________________________
sql-ledger-users mailing list
sql-ledger-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users