X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/88dea78ecdb77761f71c5016ca97e53b2d55d9d3..7afe92aff55c96742fbffb54e382f17f9fe4d907:/SL/CVar.pm

diff --git a/SL/CVar.pm b/SL/CVar.pm
index f13481207..3dba8b217 100644
--- a/SL/CVar.pm
+++ b/SL/CVar.pm
@@ -356,7 +356,7 @@ sub build_filter_query {
       next unless ($params{filter}->{$name});
 
       push @sub_where,  qq|cvar.text_value ILIKE ?|;
-      push @sub_values, '%' . trim($params{filter}->{$name}) . '%'
+      push @sub_values, like($params{filter}->{$name});
 
     } elsif ($config->{type} eq 'select') {
       next unless ($params{filter}->{$name});
@@ -419,12 +419,12 @@ sub build_filter_query {
 
       my $table = $config->{type};
       push @sub_where, qq|cvar.number_value * 1 IN (SELECT id FROM $table WHERE name ILIKE ?)|;
-      push @sub_values, "%" . trim($params{filter}->{$name}) . "%";
+      push @sub_values, like($params{filter}->{$name});
     } elsif ($config->{type} eq 'part') {
       next unless $params{filter}->{$name};
 
       push @sub_where, qq|cvar.number_value * 1 IN (SELECT id FROM parts WHERE partnumber ILIKE ?)|;
-      push @sub_values, "%" . trim($params{filter}->{$name}) . "%";
+      push @sub_values, like($params{filter}->{$name});
     }
 
     if (@sub_where) {