[ valajbeg @ 31.01.2008. 13:04 ] @
npr: declare @varijabla varchar(30), @test int, @var varchar(30), @var1 varchar(2),@rez varchar(30), @br int set @varijabla = 'UK1UK2UK3US3US9' set @test = 1 set @br = 1 set @var = SUBSTRING(@varijabla, @br, @br + 3) while @test < len(@varijabla) begin set @var = SUBSTRING(@varijabla, @br, @br + 3) if left(@var,2) = 'UK' set @rez = @rez + @var set @br = (@br + 3) set @test = (@test + 3) end print @rez ------------------------------------------------------------------------------------------ Ovaj rezultat mi vrati "NISTA" : ) pokusavao sam da umjesto obicnog "sabiranja" da uradim "select (@rez + @var) as @rez) al' ne moze ni to ...pokusao sam i da ova druga "@rez" bude neka druga varijabla.. ali ni to ne moze... ima li neko neko rijesenje? p.s. Server 2000 |