Tech Tip: The new functionality of the Replace string command
PRODUCT: 4D | VERSION: 11 | PLATFORM: Mac & Win
Published On: March 18, 2009
In 4D v11 SQL, the Replace string command gained a fith parameter: an optional "*" as the last parameter passed when calling this command.
The * parameter allows comparisons to be based on character codes. It will let you replace special characters (carriage returns, Char(1), etc.) and case sensitive or accented characters (a#A, a#à, etc.). Without using the * parameter, the Replace string command is not diacritical and does not accept ignorable characters according to the Unicode specification.