日期:2014-05-17 浏览次数:20626 次
DECLARE @a NVARCHAR(max)
SET @a='Christian Louboutin Black sheepskin 160mm high shoes.jpg
------解决方案--------------------
Christian Louboutin Black sheepskin 160mm high shoes_01.jpg
------解决方案--------------------
Christian Louboutin Black sheepskin 160mm high shoes_02.jpg
------解决方案--------------------
Christian Louboutin Black sheepskin 160mm high s'
SELECT REVERSE(SUBSTRING(REVERSE(@a),PATINDEX('%
------解决方案--------------------
%',REVERSE(@a))+1,LEN(@a)))
/*
----------------------------------------------------------------------------------------------------------------
Christian Louboutin Black sheepskin 160mm high shoes.jpg
------解决方案--------------------
Christian Louboutin Black sheepskin 160mm high shoes_01.jpg
------解决方案--------------------
Christian Louboutin Black sheepskin 160mm high shoes_02.jpg
*/