Sql server的left, right, charindex, patindex 函数应用

/province/shanghai/shanghai/dealer/shcypd/price
/province/shanghai/shanghai/dealer/shcypd/service
/province/jiangsu/suzhou/dealer/szchsfl/price
/province/shanghai/shanghai/dealer/shcypd

获取dealer/后  下一个/之前的 字符串

select LEFT( 
(right(name,(len(name)-(charindex('/dealer',name)+7)))+'/'), 
patindex('%[/]%',
(right(name,(len(name)-(charindex('/dealer',name)+7)))+'/')
)-1)
 from table_1