summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xLedgerSMB/CT.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/LedgerSMB/CT.pm b/LedgerSMB/CT.pm
index 1477b9fc..e40b3336 100755
--- a/LedgerSMB/CT.pm
+++ b/LedgerSMB/CT.pm
@@ -608,7 +608,7 @@ sub search {
if ( $form->{address} ne "" ) {
$var = $dbh->quote( $form->like( lc $form->{address} ) );
$where .=
-" AND (lower(ct.address1) LIKE $var OR lower(ct.address2) LIKE '$var')";
+" AND (lower(ct.address1) ILIKE $var)";
}
if ( $form->{startdatefrom} ) {