How can I execute something like this using executeSqlQuery script
<queryDef label="Agent Guid" sql="SELECT REPLACE('[$CustomField$]','<a href="','test')" />The xml file becomes erroneous because of the double quote under '<a href="'.
<queryDef label="Agent Guid" sql="SELECT REPLACE('[$CustomField$]','<a href="','test'")" />
Could it be that you missed one double quote; must always be in pairs of 2