I have a SAP table with a Key column lets say Member ID with number values but with Zeros appended in the front. All the values in member ID are of length 6 so if the member ID is 789 , the column shoes it like 000789 and for 87 it is showing as 000087.
i want to link this table with another table which has member ID but the values there dont have appended Zeros so the member ID woul read like 789 and 87. i am facing diffciulty in linking them. I think there would a string fuction to do the same but I m not able to find a solution for the same.
