1.字符串截取(2015-7-8)
reverse函数-将字符串逆序
declare @string VARCHAR(20)
set @string='省份-城市'
select substring(@string,1,len(@string) - charindex('-',reverse(@string)))
select substring(@string,charindex('-',@string)+1,len(@string) - charindex('-',@string)+1)
--------------------
省份
(1 行受影响)
--------------------
城市
(1 行受影响)