Index: /branches/dev/data/class/SC_CustomerList.php
===================================================================
--- /branches/dev/data/class/SC_CustomerList.php	(revision 223)
+++ /branches/dev/data/class/SC_CustomerList.php	(revision 224)
@@ -90,5 +90,9 @@
 		//¡¡Ì¾Á°¡Ê¥«¥Ê¡Ë
 		if ( strlen($this->arrSql['kana']) > 0 ) {
-			$this->setWhere("(kana01 || kana02 LIKE ?)");
+			if(DB_TYPE == "pgsql"){
+				$this->setWhere("(kana01 || kana02 LIKE ?)");
+			}elseif(DB_TYPE == "mysql"){
+				$this->setWhere("concat(kana01,kana02) LIKE ?" );
+			}
 			$searchKana = $this->addSearchStr($this->arrSql['kana']);
 			$this->arrVal[] = mb_ereg_replace("[ ¡¡]+","",$searchKana);
@@ -103,5 +107,9 @@
 		//¡¡ÅÅÏÃÈÖ¹æ
 		if ( is_numeric( $this->arrSql['tel'] ) ) {
-			$this->setWhere( "(tel01 || tel02 || tel03 LIKE ?)" );
+			if(DB_TYPE == "pgsql"){
+				$this->setWhere( "(tel01 || tel02 || tel03 LIKE ?)" );
+			}elseif(DB_TYPE == "mysql"){
+				$this->setWhere("concat(tel01,tel02,tel03) LIKE ?" );
+			}
 			$searchTel = $this->addSearchStr($this->arrSql['tel']);
 			$this->arrVal[] = ereg_replace("-", "", $searchTel);