字符拆分

[yangxinjia]

500-1000拆分 ，取500 和 1000

[tim_spac]

declare @o varchar(16) set @o = '500-1000'
declare @l varchar(16), @r varchar(16)
select
   @l = left(@o, charindex('-',@o)-1)
  ,@r = right(@o, len(@o) - charindex('-',@o))

select @l, @r

[中国风]

declare @s nvarchar(100)
set @s='500-1000'
select left(@s,charindex('-',@s)-1),stuff(@s,1,charindex('-',@s),'')

[中国风]

declare   @s   nvarchar(100) 
set   @s='500-1000' 
select   left(@s,charindex('-',@s)-1),stuff(@s,1,charindex('-',@s),'')

                                                                                                                                            
-------------------------------------------------- 500                                                1000

（所影响的行数为 1 行）