sql 截取两个字符串之间的字符

select SUBSTRING(templatepath,CHARINDEX('/',templatepath)+1,CHARINDEX('.', templatepath)-CHARINDEX('/', templatepath)-1)as tt
from tz_tasktemplate
order by templatecode desc