Description |
Noted that teh field in tblAPVendor.strVendorAccountNum is currently an nvarchar (15)
it should be extended to varchar (50)
update tblAPVendor
set strVendorAccountNum=left(rtrim(
convert (Varchar(30),ssvnd_our_cus_no)
),15) from tblAPVendor inner join
ssvndmst on strVendorPayToId=ssvnd_vnd_no collate Latin1_General_CI_AS
where (strVendorAccountNum is null or rtrim(strVendorAccountNum)='')
and ssvnd_our_cus_no is not null
The table says 15 thru object exploer
!pastedImage_d38293_0.png!
!pastedImage_d38293_1.png!
|