Converting a 15 digit Salesforce record Id to 18 digit

I am having a 15 digit Salesforce Id. Now I have to do a string comparison with a list of Ids which are all 18 digits. So, initially I thought of truncating them to 15 digits but that's not a good idea because of case insensitive issue. So, I want to convert the 15 digit Id into 18 digit and then run the comparison. How could I do that conversion in dbAmp?

1 person has
this question