The REPLACE string function returns a different column width in Sybase IQ 12.6, if the replace string is wider than the search string. This change may alter the formatting of some reports. If you need to control the width of the resulting column when the replace string is wider than the search string, use the CAST function. For more information, see “REPLACE function [String]” in Chapter 5, “SQL Functions” of the Sybase IQ Reference Manual.
