How would you convert this HTML (from DB2) to SQL Server? LEFT JOIN (select wadoco , replace( replace( replace( replace( xmlserialize(XMLAGG(XMLELEMENT( NAME "x", CASE WHEN trim(wammcu) = '750000' THEN substr(wlmcu, 3, 7) ELSE trim(wldsc1) END ) order by wlopsq) as varchar(1000)) , '</x><x>', ' || ') , '<x>', ' || ') , '</x>', ' || ') , '&', '&') as rem_ops Continue reading...