Add Acronym at the end of Program Types UPDATE ProgramTypes SET ProgramType = 'Small Business Assistance Program (SBAP)' WHERE ProgramTypeID=8; UPDATE ProgramTypes SET ProgramType = 'Manufacturing Extension Program (MEP)' WHERE ProgramTypeID=9; UPDATE ProgramTypes SET ProgramType = 'Small Business Developement Center (SBDC)' WHERE ProgramTypeID=11; UPDATE dProgramTypes SET ProgramType = 'Small Business Assistance Program (SBAP)' WHERE ProgramTypeID=8; UPDATE dProgramTypes SET ProgramType = 'Manufacturing Extension Program (MEP)' WHERE ProgramTypeID=9; UPDATE dProgramTypes SET ProgramType = 'Small Business Developement Center (SBDC)' WHERE ProgramTypeID=11;

THE FOLLOWING CHANGES WERE MADE

  1. Smaill Business Assistance Program changed to Small Business Assistance Program (SBAP)

  2. Manufacturing Extension Program changed to Manufacturing Extension Program (MEP)

  3. Small Business Developement Center changed to Small Business Developement Center (SBDC)

     The query did not update the fields.