I have a column that holds values like this: OPBM-20, OBMM-10, OPMD-30, etc.

Is there a way to do a SELECT that only selects the portion before the hyphen? I need something like ListFirst or GetToken, but I can't seem to find anything in SQL that does this.