22,209
社区成员
发帖
与我相关
我的任务
分享
--> 测试数据: #T
if object_id('tempdb.dbo.#T') is not null drop table #T
go
create table #T (Size varchar(5))
insert into #T
select '2*3*4' union all
select '4*8*3' union all
select '3*8*4'
select parsename(replace(Size,'*','.'),3) as L,
parsename(replace(Size,'*','.'),2) as W,
parsename(replace(Size,'*','.'),1) as H from #T
/*
2 3 4
4 8 3
3 8 4
*/