Teradata conversion to SSMS

Question

Hi,

I'm trying to convert this code from teradata to SQL SSMS

Trim(Trailing ',' FROM (XmlAgg(Trim(CONCAT(CPN.Origin,'-',CPN.Destination))|| ' ' || ',' ORDER BY CPN.CouponNumber) (VARCHAR(250)))) AS "Route",  

I tried working on this but there's no luck
TRIM(',', FROM CONCAT(CPN.Origin + '-' + CPN.Destination + '' + ',' ORDER BY CPN.CouponNumber) AS "TestRoute"

Basically the goal of this query is to identify all the possible routes from a single Primary key