insert into record0

select * from record001

where

left(FirstCol, 2) = '00' AND

(

agency is null

or trans_id is null

or ISNUMERIC(trans_id)=0

or isnumeric(accounts_trans)=0

or isnumeric(baccounts)=0

or isnumeric(daccounts)=0

or isnumeric(osa)=0

)