22,210
社区成员
发帖
与我相关
我的任务
分享
select jsdx,SUBSTRING(jsdx,1, (case when CHARINDEX(',',jsdx) = 0 then len(jsdx) else CHARINDEX(',',jsdx) - 1 end)) from rwd01
--方法一
select jsdx,SUBSTRING(jsdx,1,CHARINDEX(',',jsdx)-1) jsdx from rwd01 where CHARINDEX(',',jsdx) > 0
union all
select jsdx,jsdx from rwd01
--方法二
select jsdx,(case when CHARINDEX(',',jsdx) > 0 then SUBSTRING(jsdx,1,CHARINDEX(',',jsdx)-1) else jsdx end) jsdx from rwd01
select jsdx,SUBSTRING(jsdx,1,CHARINDEX(',',jsdx+',')-1) from rwd01
--try
select jsdx,SUBSTRING(jsdx+',',1,CHARINDEX(',',jsdx+',')-1) from rwd01