reverse(substring(reverse(DEPARTMENT),1,charindex('-',reverse(DEPARTMENT)) - 1))
根据字符串分组取最后一组
最新推荐文章于 2024-01-11 22:41:07 发布
reverse(substring(reverse(DEPARTMENT),1,charindex('-',reverse(DEPARTMENT)) - 1))