DB2 to SQL conversion

Question

I need to convert below DB2 query to SQL.

 SUBSTR(xmlserialize(xmlagg(xmltext(CONCAT( ', ',DEL.COVERAGE_CODE))) as VARCHAR(1024)), 3) as COVERAGE_CODE

 

I am not able to get equivalents of xml related things in SQL. Any help would be appreciated