MOVE 99 TO staff-id EXEC ADO SELECT last_name INTO :lname FROM staff WHERE staff_id=:staff-id END-EXEC EXEC ADO SELECT staff_id INTO :staff-id FROM staff WHERE first_name = 'Phil' END-EXEC