CARİ NOLARDA HATALI OLANLARI DÜZELTME     



UPDATE VE_ACT SET ACTNO=
SUBSTRING(ACTNO,0,5)+CONVERT(NVARCHAR,(SUBSTRING(ACTNO,5,2)+20104))
WHERE COMPANYID=21 AND
ACTNO LIKE '120.%' AND
LEN(ACTNO) =6


MUHASEBE KODLARININ DÜZELTİLMESİ
     UPDATE VE_ACC SET ACCNO=
SUBSTRING(ACCNO,0,5)+CONVERT(NVARCHAR,(SUBSTRING(ACCNO,5,2)+20104))
WHERE COMPANYID=21 AND
ACCNO LIKE '120.%' AND
LEN(ACCNO) =6