SQL Join

Hi

I have 2 tables that I want to join, the two fields I wish to join on are both the same data type “VARCHAR2(20)” however field one contains data in the format “99999999” while field two contains data in the format “99999999/9”. There is a unique match on characters 1-8 on both fields in the tables.

I did think of adding on the “/9” to field one but was unsure how to go about this. Any help would be most appreciated.

Thanks