前面所列字符如果字符数不变，可以这么写select cast(cast(substring(字符,27,8) as int) as nvarchar(8))+substring('字符',24,2) from 表
