110,537
社区成员
发帖
与我相关
我的任务
分享
select substring(col,0,charindex(',',col)) as col1,
substring(substring(substring(col,charindex(',',col)+1,len(col)),0,charindex(',',substring(substring(col,charindex(',',col)+1,len(col)))) as col2,
case when
substring(substring(substring(col,charindex(',',col)+1,len(col)),charindex(',',substring(substring(col,charindex(',',col)+1,len(col))))+1,len(substring(substring(col,charindex(',',col)+1,len(col)))='1'
then
1
end as '1',
……
from tablename