declare @str varchar(100),@str_n varchar(100)
set @str ='00005101A,00005101B,00005101C'
set @str_n = left(@str,charindex(',',@str)-2)
set @str_n = @str_n + '('+replace(@str,@str_n,'')+')'
select @str_n
set @str ='00005101A,00005101B,00005101C'
set @str_n = left(@str,charindex(',',@str)-2)
set @str_n = @str_n + '('+replace(@str,@str_n,'')+')'
select @str_n
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货