Sql server 截取指定位置到某个字符之间的内容

select SUBSTRING( SUBSTRING(Name,0, CHARINDEX('.',Name)),start,DATALENGTH(SUBSTRING(Name,0, CHARINDEX('.',Name)))) from JTable