Impromptu join of unequal key lenghts & padding

[DurandDude]

Like most I'm new to Impromptu. I need to join two tables having the same data but the keys are in different formats. Table A has part numbers that are 8 positions, right justified and blank filled. Table B has a 15 position part number that is right justified and zero filled. Somehow I think I need to zero fill the 8 position part number to a length of 15 before I can do the join but how do you do it?

 

[drlex]

Assuming you have rights to create joins in the catalogue, can you not use the functions in join (Catalogue->Joins-> Edit tab, view as Definition radio button) to do this?

Sounds like number-to-string(tableA.partno) = right(tableB.partno,8) or tableB.partno = string-to-number(tableB.partno) or similar ought to do it.
HTH
lex