declare @vc1 varchar(255), @vc2 varchar(255), @vc3 varchar(255), @count int,
        @textptr varbinary(16), @len int, @trunclen int
select pr_info into #t from pubs..pub_info where pub_id = '0736'
select @count = 1, @textptr = TEXTPTR(pr_info), @len = DATALENGTH(pr_info) from #t
while (@len > 0)
begin
 if @count = 1 select @vc1 = convert(varchar(255), pr_info) from #t
 if @count = 2 select @vc2 = convert(varchar(255), pr_info) from #t
 if @count = 3 select @vc3 = convert(varchar(255), pr_info) from #t
 if @len < 255 select @trunclen = @len else select @trunclen = 255
 updatetext #t.pr_info @textptr 0 @trunclen NULL
 select @count = @count + 1, @len = @len - @trunclen
end
select @vc1, @vc2, @vc3

This page was last updated on May 01, 2006 04:28 PM.