X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/kivitendo-erp.git/blobdiff_plain/a5501b166388f169f232af20d911d79528f2f5c5..8cc4ba47074672d0907a19e71617c9f468b0361e:/SL/IR.pm diff --git a/SL/IR.pm b/SL/IR.pm index 875059bfa..98a53536f 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -1007,7 +1007,7 @@ sub retrieve_item { foreach my $table_column (qw(p.partnumber p.description pg.partsgroup)) { my $field = (split m{\.}, $table_column)[1]; next unless $form->{"${field}_${i}"}; - $where .= " AND lower(${table_column}) LIKE ?"; + $where .= " AND lower(${table_column}) LIKE lower(?)"; push @values, '%' . $form->{"${field}_${i}"} . '%'; }