update cptbl
set accountnumberasint=cast(account as int)
where accountnumberasint is null
and account not like '%DEL%'