diff options
-rwxr-xr-x | LedgerSMB/CT.pm | 2 |
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} ) { |