mysql函数中concat在sqlserver函数中怎么用
例如$sql.= " and concat(bs.custom_addr_province,bs.custom_addr_city,bs.custom_addr_detail) like '%".$searchcondition["custom_addr"]."%'";
MySQL SQL SQL?Server
------解决方案--------------------
and concat(bs.custom_addr_province,bs.custom_addr_city,bs.custom_addr_detail)→and bs.custom_addr_province+bs.custom_addr_city+bs.custom_addr_detail