@"SELECT assign_dt, modify_dt, cust_id, ww_user, mobile1, mobile2, phone1, phone2,
case_result, id_cro, CASE WHEN remark.value('(/Root/EMAIL)[1]', 'varchar(100)')
<> '' THEN remark.value('(/Root/EMAIL)[1]', 'varchar(100)')
ELSE remark.value('(/Root/支付宝账号)[1]', 'varchar(100)') END AS email, id
FROM tbOBCustList
WHERE "+sql;
说明:如果root emal不为空时 读取emal 如果为空时 就读取 支付宝账号.