第3个回答 2011-06-23
create proc Myproc
as
begin
declare @t table(ichar varchar(2))
declare @char varchar(100)
declare @tb table(A1 varchar(100))
declare cur1 cursor for select itname from bd_itemdoc
open cur1
Fetch next from cur1 into @char
while @@fetch_status=0
begin
if (select count(*) from @t where charindex(ichar,@char)>0)>0
insert into @tb values(@char)
else
begin
declare @len int
set @len=len(@char)
while @len>0
begin
insert into @t values(left(@char,1))
set @len=@len-1
set @char=right(@char,@len)
end
end
Fetch next from cur1 into @char
end
close cur1
deallocate cur1
select * from bd_itemdoc where itname in(select A1 from @tb)
end
--执行方法:
--exec Myproc