SQL按照某个字符截取字符串（正序截取和倒序截取）

select substring(str,charindex('-',fnumber)+1,len(fnumber)-charindex('-',fnumber)),substring(fnumber,len(REVERSE(fnumber))-charindex('.',REVERSE(fnumber))+2,charindex('.',REVERSE(fnumber)))
from t_icitem