update tbl_PRD_Nutrition
set vitaminD_type = 'mcg'
where isNumeric(vitaminD) = 1

update tbl_PRD_Nutrition
set vitaminD_type_equv = 'mcg'
where isNumeric(vitaminD_equv) = 1

update tbl_PRD_NutritionChild
set vitaminD_type = 'mcg'
where isNumeric(vitaminD) = 1

update tbl_PRD_NutritionChild
set vitaminD_type_equv = 'mcg'
where isNumeric(vitaminD_equv) = 1