• This maybe:

    SELECT PARSENAME(REPLACE('HEYE-B RFE-IPA 70940',' ','.'),2);