From 0a7ecc6aaf613683a7d1ccd65c80b09da1fff93e Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Wed, 9 Jul 2008 20:33:01 +0000
Subject: [PATCH] perl vs SQL brainfart

---
 FS/FS/svc_Common.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/FS/FS/svc_Common.pm b/FS/FS/svc_Common.pm
index 21df6a78f..65b34c709 100644
--- a/FS/FS/svc_Common.pm
+++ b/FS/FS/svc_Common.pm
@@ -49,7 +49,7 @@ sub search_sql_field {
   my( $class, $field, $string ) = @_;
   my $table = $class->table;
   my $q_string = dbh->quote($string);
-  "lc($table.$field) = lc($q_string)";
+  "LOWER($table.$field) = LOWER($q_string)";
 }
 
 #fallback for services that don't provide a search... 
-- 
2.11.0