Stopping APEX from converting & to &
Its that simple, Its converting & to & in a select list. All I want is a space before the letter. I have tried everything I can think of. All other post I can find say to do the htf.escape and unistr but none produce a space. I have tried the following
SELECT htf.escape_sc(' ') || 'A' D, RPT R from dual;
SELECT htf.escape_sc('\00a0') || 'A' D, RPT R from dual;
SELECT UNISTR(' ') || 'A' D, RPT R from dual;
SELECT UNISTR('\00a0') || 'A' D, RPT R from dual;
This worked great in 3.2, Trying to move this to 4.1.