I have a launch page that uses the below code in an embedded procedure:

TABLE FILE rp_rm_dw_project
SUM FST.RP_RM_DW_PROJECT.RP_RM_DW_PROJECT.PRJID
 BY RP_RM_DW_PROJECT.RP_RM_DW_PROJECT.PRJNAME
WHERE PRJNAME LIKE '_.%';
ON TABLE PCHOLD FORMAT XML
END

Unfortunately, the contents of PRJNAME sometimes contain ampersands (&), which in the generated XML are copied verbatim instead of being turned into an XML entity (& amp; ). For example:

<td colnum="c0">4. R&D Program</td>

The net effect is that (in Internet Explorer) entries in my dropdown are cut off before the ampersand!

Although I have to admit that it's stupid of IE to interpret non-entities as entities, that ampersand probably should have been escaped in the XML already.

So, I have a few questions:

• Is this a known issue?
  
• What's a good workaround that I can use in an embedded procedure? Do I really need to create a HOLD-file (my hopefully temporary work-around) to solve this?
  

This message has been edited. Last edited by: Kerry,

You can try to replace the & value in the fields of your database.

Create a defined field NEW_PRJNAME with the same size and use a formula to replace the & for an other character (+)