Recent changes to 13: REPLACE() function and zero-length 3rd argumenthttps://sourceforge.net/p/cloudbase/bugs/13/2009-06-16T09:57:08ZRecent changes to 13: REPLACE() function and zero-length 3rd argumentREPLACE() function and zero-length 3rd argument2009-06-16T09:57:08Z2009-06-16T09:57:08ZYoungWoo Kimhttps://sourceforge.net/u/warwithin/https://sourceforge.net7105b71d8840c2a83151272ee9357d1060c716c1<div class="markdown_content"><p>Oracle:<br />
SELECT REPLACE( 'AAbbAA', 'A', '') FROM DUAL;<br />
It returns 'bb'.</p>
<p>MySQL:<br />
SELECT REPLACE( 'AAbbAA', 'A', '');<br />
It Also returns 'bb'.</p>
<p>CloudBase:<br />
SELECT REPLACE( 'AAbbAA', 'A', '') FROM DUAL;<br />
CB returns NULL.</p></div>