sql server按要求截取想要的字符

我是大傻子333*242*222 生活是是是是

create proc  ccc
as
declare @cur cursor,
@pp_length decimal(20,8),
@pp_width decimal(20,8),
@pp_height decimal(20,8),
@length  nvarchar(30),
@width nvarchar(30),
@height  nvarchar(30),
@item nvarchar(30),
@description nvarchar(100)


create table @a--创建虚拟表
(
   length nvarchar(30),
   width nvarchar(30),
   height nvarchar(30),
   length1 decimal(20,8),
   width1 decimal(20,8),
   height1 decimal(20,8),
   item nvarchar(30),
   description nvarchar(100)
)
set @cur = cursor static for 
select pp_length,pp_width,pp_height,description,item from 表名
open @cur
while(1=1)
begin
fetch next from @cur into @pp_length,@pp_width,@pp_height,@description,@item
if(@@FETCH_STATUS <> 0)
break
set @length = right(left(@description,charindex('*',@description)-1),3)
set @width = left(Stuff(@description,1,charindex('*',@description),''),charindex('*',stuff(@description,1,charindex('*',@description),''))-1)
set @height = SUBSTRING( Stuff(@description,1,charindex('*',@description),''),5,3)
if( @length <> ltrim(rtrim(cast(cast(@pp_length as int) as nvarchar(30)))) or
 @width <> ltrim(rtrim(cast(cast(@pp_width as int) as nvarchar(30)))) or
@height <> ltrim(rtrim(cast(cast(@pp_height as int) as nvarchar(30)))))
insert into @a values (@length,@width,@height,@pp_length,@pp_width,@pp_height,@item,@description)
end
close @cur
deallocate @cur
select * from @a