Cacher is the code snippet organizer for pro developers

SELECT
  STUFF(
    (
      SELECT 
        ',' + RTRIM(LTRIM(TELEFONO))
			FROM CLIENTE
			WHERE CLIENTE = '10655'
			ORDER BY TELEFONO FOR xml path('')
		)
    , 1, 1, '')