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