UPDATE billing SET ndc_info = code, code = '112142101' WHERE code LIKE '11214201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '112142101' WHERE code LIKE '11214202' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '112141101' WHERE code LIKE '11214101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '112141102' WHERE code LIKE '11214102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111113102' WHERE code LIKE '11111302' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111113101' WHERE code LIKE '11111301' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '145212301' WHERE code LIKE '14521201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111123101' WHERE code LIKE '11112301' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111123102' WHERE code LIKE '11112302' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111120103' WHERE code LIKE '11112001' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111123103' WHERE code LIKE '11112303' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '113172101' WHERE code LIKE '11317201' AND code_type LIKE 'MA';
-- UPDATE billing SET ndc_info = code, code = '113170101' WHERE code LIKE '11317002' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '113170102' WHERE code LIKE '11317001' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111101102' WHERE code LIKE '11110102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111101101' WHERE code LIKE '11110101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '121181901' WHERE code LIKE '12118101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '121181202' WHERE code LIKE '12118102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '121181203' WHERE code LIKE '12118103' AND code_type LIKE 'MA';
-- UPDATE billing SET ndc_info = code, code = '122162901' WHERE code LIKE '12218210' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182302' WHERE code LIKE '12218209' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182203' WHERE code LIKE '12218203' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252223202' WHERE code LIKE '25222303' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252224101' WHERE code LIKE '25222401' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252223301' WHERE code LIKE '25222302' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252225902' WHERE code LIKE '25222502' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252225703' WHERE code LIKE '25222503' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252225201' WHERE code LIKE '25222501' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252225904' WHERE code LIKE '25222504' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252226901' WHERE code LIKE '25222601' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252226903' WHERE code LIKE '25222603' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252223302' WHERE code LIKE '25222302' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255253309' WHERE code LIKE '25525309' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253231901' WHERE code LIKE '25323101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253231202' WHERE code LIKE '25323102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253231103' WHERE code LIKE '25323103' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253231304' WHERE code LIKE '25323104' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '254245001' WHERE code LIKE '25424501' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255254405' WHERE code LIKE '25525405' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255253202' WHERE code LIKE '25525302' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255253301' WHERE code LIKE '25525301' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255253103' WHERE code LIKE '25525303' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255255401' WHERE code LIKE '25525501' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255254204' WHERE code LIKE '25525404' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255254103' WHERE code LIKE '25525403' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255254301' WHERE code LIKE '25525401' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255256201' WHERE code LIKE '25525601' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255254902' WHERE code LIKE '25525402' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255254906' WHERE code LIKE '25525406' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256260901' WHERE code LIKE '25626701' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256262901' WHERE code LIKE '25626201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256262402' WHERE code LIKE '25626202' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256262403' WHERE code LIKE '25626203' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256261201' WHERE code LIKE '25626101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256268902' WHERE code LIKE '25626802' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256268901' WHERE code LIKE '25626801' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256268903' WHERE code LIKE '25626803' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258288101' WHERE code LIKE '25828101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258281101' WHERE code LIKE '25828301' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258283101' WHERE code LIKE '25828601' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258286101' WHERE code LIKE '25828801' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '371311901' WHERE code LIKE '37131101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '373601901' WHERE code LIKE '37360101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '373601203' WHERE code LIKE '37364101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '373601502' WHERE code LIKE '37360102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '373601502' WHERE code LIKE '37360104' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255255102' WHERE code LIKE '25525502' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374701201' WHERE code LIKE '37470101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374701202' WHERE code LIKE '37470102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374701204' WHERE code LIKE '37470104' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374701206' WHERE code LIKE '37470106' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374701203' WHERE code LIKE '37470103' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374701205' WHERE code LIKE '37470105' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253232101' WHERE code LIKE '25323201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253232403' WHERE code LIKE '25323203' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253232202' WHERE code LIKE '25323202' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258284401' WHERE code LIKE '25828401' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258284702' WHERE code LIKE '25828402' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374781201' WHERE code LIKE '37478101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252222201' WHERE code LIKE '25626501' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256265601' WHERE code LIKE '25626502' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256264107' WHERE code LIKE '25626407' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256265105' WHERE code LIKE '25626505' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256265503' WHERE code LIKE '25626503' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256265306' WHERE code LIKE '25626506' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256265904' WHERE code LIKE '25626504' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '254243201' WHERE code LIKE '25424301' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '254244401' WHERE code LIKE '25424401' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374761003' WHERE code LIKE '37476103' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374761002' WHERE code LIKE '37476102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374761007' WHERE code LIKE '37476107' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374761006' WHERE code LIKE '37476106' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374761001' WHERE code LIKE '37476101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '374761005' WHERE code LIKE '37476105' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992901' WHERE code LIKE '49299201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992910' WHERE code LIKE '49299202' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992909' WHERE code LIKE '49299203' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '145211101' WHERE code LIKE '14521101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '141200901' WHERE code LIKE '14120001' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '261291901' WHERE code LIKE '26129101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '260290901' WHERE code LIKE '26029001' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255258401' WHERE code LIKE '25525801' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '255258902' WHERE code LIKE '25525802' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253235905' WHERE code LIKE '25323505' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253234901' WHERE code LIKE '25323401' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253235101' WHERE code LIKE '25323501' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253235304' WHERE code LIKE '25323504' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253235203' WHERE code LIKE '25323503' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253235102' WHERE code LIKE '25323502' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253235906' WHERE code LIKE '25323506' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '253234104' WHERE code LIKE '25424101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '254241902' WHERE code LIKE '25424102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '254242107' WHERE code LIKE '25424103' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '254242101' WHERE code LIKE '25424201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '258289102' WHERE code LIKE '25828901' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256269101' WHERE code LIKE '25626901' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252227902' WHERE code LIKE '25222702' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252227101' WHERE code LIKE '25222701' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252221101' WHERE code LIKE '25222101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '373641901' WHERE code LIKE '37364101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256263901' WHERE code LIKE '25626301' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '256269902' WHERE code LIKE '25626302' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182101' WHERE code LIKE '12218201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182102' WHERE code LIKE '12218202' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122181101' WHERE code LIKE '12118101' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122181102' WHERE code LIKE '12118102' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '141200902' WHERE code LIKE '12218201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '262295901' WHERE code LIKE '26229501' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992902' WHERE code LIKE '49299202' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992903' WHERE code LIKE '49299203' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992904' WHERE code LIKE '49299204' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992905' WHERE code LIKE '49299205' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992906' WHERE code LIKE '49299206' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992907' WHERE code LIKE '49299207' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992908' WHERE code LIKE '49299208' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111120103' WHERE code LIKE '11112002' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '111123102' WHERE code LIKE '11112201' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122181101' WHERE code LIKE '12218104' AND code_type LIKE 'MA' AND code_text LIKE 'Min%';
UPDATE billing SET ndc_info = code, code = '122182102' WHERE code LIKE '12218104' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122181101' WHERE code LIKE '12218105' AND code_type LIKE 'MA' AND code_text LIKE 'Min%';
UPDATE billing SET ndc_info = code, code = '122181102' WHERE code LIKE '12218105' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122181102' WHERE code LIKE '12218106' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182302' WHERE code LIKE '12218204' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182203' WHERE code LIKE '12218205' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '141200902' WHERE code LIKE '14120007' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '252224101' WHERE code LIKE '25222304' AND code_type LIKE 'MA';
-- UPDATE billing SET ndc_info = code, code = '373601903' WHERE code LIKE '37360103' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '492992910' WHERE code LIKE '49299210' AND code_type LIKE 'MA';

-- Replacements for commented items above:
UPDATE billing SET ndc_info = code, code = '113170102' WHERE code LIKE '11317002' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '373601203' WHERE code LIKE '37360103' AND code_type LIKE 'MA';
UPDATE billing SET ndc_info = code, code = '122182901' WHERE code LIKE '12218210' AND code_type LIKE 'MA';

-- Repairs of the above from running previous versions of this script:
UPDATE billing SET code = '113170102' WHERE ndc_info LIKE '11317002' AND code_type LIKE 'MA';
UPDATE billing SET code = '373601203' WHERE ndc_info LIKE '37360103' AND code_type LIKE 'MA';
UPDATE billing SET code = '122182901' WHERE ndc_info LIKE '12218210' AND code_type LIKE 'MA';

