I want to join two tables on repositoty file (RPD), where the table1 key is a substring of table2 key.
Do you know the sintax that I should use?
checkout this link.
I'm using SUBSTRING(<<FIELD>> FROM 1 FOR 3), if I have the FIELD = '12ABC', it will return '12A' or '2AB'?
SUBSTRING(<<FIELD>> FROM 1 FOR 3) means that start on the first character and will count 3 character to do the substring.
For the example above it will appear '12A'
To do that you should use a complex join, and the substring.
The substring sintax is SUBSTRING(<<FIELD>> FROM <<NUMBER FIRST CHAR>> FOR <<LENGHT>>).