sqlserver分隔符截取

分类: IT文章 • 2022-05-19 21:59:28

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