From ef07ad1fede1a067169794ba9b457e5b82116628 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Wed, 11 Jun 2014 15:05:31 +0200
Subject: [PATCH] Bug 9811: Cardnumber could be alphanumeric

---
 C4/Utils/DataTables/Members.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm
index 2edbc50..992d67f 100644
--- a/C4/Utils/DataTables/Members.pm
+++ b/C4/Utils/DataTables/Members.pm
@@ -30,7 +30,7 @@ sub search {
     my $select = "SELECT
         borrowers.borrowernumber, borrowers.surname, borrowers.firstname, borrowers.address,
         borrowers.address2, borrowers.city, borrowers.zipcode, borrowers.country,
-        CAST(borrowers.cardnumber AS UNSIGNED) AS cardnumber, borrowers.dateexpiry,
+        cardnumber, borrowers.dateexpiry,
         borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
         categories.description AS category_description, categories.category_type,
         branches.branchname";
-- 
2.0.0.rc2