Fair enuff. In the scenario I was using it I wanted to get rid of 3 letters that had been added to a file number e.g

CaseCode: 1017856AVN.

In database wanted to link it to the file number & file type were in separate columns i.e.

Case number: 1017856 Case type: AVN

So to get CaseCode in 1st DB to match Case number in 2nd DB Kingston's REPLACE worked fine.