sqlserver存储过程中对字符串截取

Question

字符串@str='DAITU_YUNPAN_20141120.txt'
我要获取 20141120

Answer 1

select substring('DAITU_YUNPAN_20141120.txt',charindex('.','DAITU_YUNPAN_20141120.txt')-8,8)