>Dear Sergey
>
>If table is as
>
>insert into table1 values ('1401',0)
>insert into table1 values ('1401007',0)
>insert into table1 values ('1401010',0)
>insert into table1 values ('1401025',0)
>insert into table1 values ('1402',1)
>insert into table1 values ('1402088',0)
>insert into table1 values ('1402101',0)
>insert into table1 values ('1402225',0)
>insert into table1 values ('1403',0)
>insert into table1 values ('1403088',0)
>insert into table1 values ('1403101',0)
>insert into table1 values ('1403225',0)
>
>Please imagine in tbale qty of 1402 is 1
>
>How to make qty=1 against all codes begins with 1402
>
>I do not use 1402 in procedure, the procudure must automatically detect qty=1 against any code begins with four character length.
Does this one do what you want?:
UPDATE table1 ;
SET qty = 1 ;
WHERE ;
LEN(TRIM(code)) > 4 ;
AND LEFT(code,4) in ( ;
Select code ;
From table1 ;
WHERE qty = 1 AND LEN(TRIM(code)) = 4 ;
)
hth
-Stefan