字符拆分

Question

500-1000拆分  ，取500 和 1000

Answer 1

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

Answer 2

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

Answer 3

declare   @s   nvarchar(100) 
set   @s='500-1000' 
select   left(@s,charindex('-',@s)-1),stuff(@s,1,charindex('-',@s),'')                                                                                                                                            
-------------------------------------------------- 500                                                1000（所影响的行数为 1 行）