日期:2014-05-18 浏览次数:20749 次
create table tb(a int,b varchar(100))
insert into tb
select 1103 ,'\124\\126\' union all
select 1365 ,'\124\\475\\231\' union all
select 1303 ,'\136\\167\'
go
select a.a,
'\'+substring(replace(replace(a.b,'\\',','),'\',''),b.number,
charindex(',',replace(replace(a.b,'\\',','),'\','')+',',b.number)-b.number)+'\' b
from tb a,master..spt_values b
where b.[type] = 'p' and b.number between 1 and len(replace(replace(a.b,'\\',','),'\',''))
and substring(','+replace(replace(a.b,'\\',','),'\',''),b.number,1) = ','
drop table tb
/***********************************
a b
----------- ----------------------------------------------------------------------------------------------------------------
1103 \124\
1103 \126\
1365 \124\
1365 \475\
1365 \231\
1303 \136\
1303 \167\
(7 行受影响)