Index: branches/dev/data/class/SC_CustomerList.php
===================================================================
--- branches/dev/data/class/SC_CustomerList.php	(revision 14107)
+++ branches/dev/data/class/SC_CustomerList.php	(revision 14109)
@@ -80,5 +80,5 @@
 		if ( strlen($this->arrSql['name']) > 0 ) {
 			if(DB_TYPE == "pgsql"){
-				$this->setWhere("(name01 || name02) LIKE ?" );
+				$this->setWhere("(name01 || name02 LIKE ?)" );
 			}elseif(DB_TYPE == "mysql"){
 				$this->setWhere("concat(name01,name02) LIKE ?" );
@@ -92,5 +92,5 @@
 		if ( strlen($this->arrSql['kana']) > 0 ) {
 			if(DB_TYPE == "pgsql"){
-				$this->setWhere("(kana01 || kana02) LIKE ?");
+				$this->setWhere("(kana01 || kana02 LIKE ?)");
 			}elseif(DB_TYPE == "mysql"){
 				$this->setWhere("concat(kana01,kana02) LIKE ?" );
@@ -218,6 +218,7 @@
         					$sql_where .= "dtb_customer.email ILIKE ? ";
         				} else {
-        					$sql_where .= "OR dtb_customer.email ILIKE ? " ;
+        					$sql_where .= "OR dtb_customer.email LIKE ? " ;
         				}
+                        $sql_where = "(".$sql_where.")";
         			}
         			$searchDomain = $this->addSearchStr($val);