SELECT SUBSTR(vendors.vendor_name, (INSTR(vendors.vendor_name, ' ') -1)) AS vendor_first
       FROM vendors;