SELECT BussinessNo = STUFF(REPLACE(REPLACE((SELECT N.business_no FROM T_delegate_list N WHERE N.g_mode = ‘LR077639‘FOR XML AUTO),‘<N business_no="‘, ‘|‘),‘"/>‘,‘‘),1,1,‘‘)
SQL 列提取组成字符串
原文：http://www.cnblogs.com/Andy-Li/p/5199974.html
