hi

this code doesn`t work

my table look like:

1 2 3.. n

a c d g

b d f g

I will go with cursor...

ok thanks for answer, because I suspect that it is not random 😀

ok but why this code

DECLARE @i INT

DECLARE @j-2 INT

SET @i = 1

SET @j-2 = 1

WHILE @j-2 < 100000

BEGIN

SET @i = (SELECT TOP 1...

Anyone?

But I have also some more questions.

select DATALENGTH(SUBSTRING('URGO OBLIŽ ZA RANE IN ODRGNINE, 5 OBLIŽEV', 1, 35))

this return 35 OK

declare @txt_value nvarchar(100)

set @txt_value = 'URGO OBLIŽ ZA RANE IN ODRGNINE,...

It works thanks 😉