sql中截取指定字符的前几位

2024-11-20 02:38:23
推荐回答(1个)
回答1:

select substring(ID,charindex('.',ID)+1,(charindex('$',ID)-charindex('.',ID)-1)) as idx