Transact SQL: Equivalente a GROUP_CONCAT de MySQL
SELECT STUFF( ( SELECT ',' + RTRIM(LTRIM(TELEFONO)) FROM CLIENTE WHERE CLIENTE = '10655' ORDER BY TELEFONO FOR xml path('') ) , 1, 1, '')