This is using the adventureworks2019 database

5) Create an insert/update trigger on the Vendors table that uppercases and trims the follwing fields: (VendorName. VendorAddress 1, VendorAddress2, VendorCity. VendorState VendorContractL Name, and VendorContactFName) Create an insert and update statement with lowercase values to test your trigger. Show a select of the table afterwords to prove your trigger worked.