SQL中分列的问题

[wysfair]

有表T1如下
Size
---------------
2*3*4
4*8*3
3*8*4
...

现要用SQL语句用*号分出三列得出以下结果

L W H
-------------------------------
2 3 4
4 8 3
3 8 4
...


希望大大们帮一下...感谢

[lihan6415151528]

SELECT LEFT(SIZE,CHARINDEX('*')[l]

[nzperfect]

--> 测试数据: #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
*/