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
www.microsoft.ba
Microsoft gives you Windows... Linux gives you the whole house.
Microsoft gives you Windows... Linux gives you the whole house.