sql - comparing two strings with a different format but same meaning -

is there way can use compare 2 strings 12 ad e4 9f , 12:ad:e4:9f , result says similar. there stored in different tables , create view joining tables using strings joining criteria

you can convert second string upper case , remove ' ' , ':' before comparing strings

select upper(replace('12:ad:e4:9f',':',' ') dual;