By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table employees (employee_id varchar(255))
insert into employees values ('Jason-21996'), ('Buttler')
select e.*, regexp_substr(employee_id, '^[^-]+')
from employees e
| EMPLOYEE_ID | 2 |
|---|---|
| Jason-21996 | Jason |
| Buttler | Buttler |