Joining RAW field with CHAR field
I need to join two tables within one view. In table 1 there is a ID of RAW/16. The same value but in different type (char/70) is placed in table 2. How can I manage a join on that IDs with these tables? I tried to convert the types by using FM SCMS_TEXT_TO_BINARY. Unfortunatly this converts not only the type but also the value which has to be the exactly same after "type conversion".
Many thanks in advance!