declare @t table ( col varchar(50) )insert @t select 'STBZ-OPP印刷单张膜-0.04*37.5cm' union all select 'sdf-CPP单张复合膜-0.02*490MM ' union all select 'ST-OPP单张印刷膜-0.03*480MM 'select substring(col,charindex('-',col)+1,len(col)) from @t select stuff(col,1,charindex('-',col),'') from @t
declare @t table
(
col varchar(50)
)insert @t select 'STBZ-OPP印刷单张膜-0.04*37.5cm'
union all select 'sdf-CPP单张复合膜-0.02*490MM '
union all select 'ST-OPP单张印刷膜-0.03*480MM 'select substring(col,charindex('-',col)+1,len(col)) from @t
select stuff(col,1,charindex('-',col),'') from @t