sqlserver分隔符截取

select
LEFT(filed,charindex(',',field,1)-1) as type,
SUBSTRING(filed,34,CHARINDEX(',',filed+',',1)-1)
from table where id = 'sdfdsfsfds'

posted @ 2019-06-17 19:07  wjj1013  阅读(948)  评论(0)    收藏  举报