RPG provides a few ways to replace characters in a string, such as the %XLATE BIF. SQL also has interesting—and, more importantly, easy to use—functions to transform strings, changing the case of its characters or replacing them altogether.
Written by Rafael Victória-Pereira
The previous article in this series discussed a set of scalar functions you can use to convert data to its representation in string format. Once this data is in string format, you can use it with text information from your files in order to create descriptions or other texts, which you can use in reports. However, these texts might require a different type of conversion; their case might not be the most adequate, or you might want to replace a character somewhere in the middle of the string. I could argue that his is also a conversion, albeit a different one.