ALTER TABLE "vendor_investigations" ALTER COLUMN "investigation_method" SET DATA TYPE varchar(100);