SQL 怎么将一列中的数据按一个分隔符分成多列显示

with HrmResource(id,lastname) as (select 167,'段秋月' union allselect 170,'杨子军'),formtable_main_78(Requestid,WTCW,XMCY) as (select 722,'xxxxx公司','167,170') select a.*,stuff(c.[col],1,1,'') [项目名称]from formtable_main_78