Replace Function In SQL 2005
Join the DZone community and get the full member experience.Join For Free
// description of your code here
SELECT DISTINCT CALL_NUMBER, Actie = Replace ( REPLACE( ( SELECT ACTIONS_DESC AS [data()] FROM dbo.CL_PROBLEM_HISTORY clh WHERE clh.CALL_NUMBER = c.CALL_NUMBER ORDER BY CALL_NUMBER, HISTORY_ORDER FOR XML PATH ('') ), ' ', ' ') , ' ', ' ') FROM dbo.CL_PROBLEM_HISTORY c ORDER BY CALL_NUMBER
Opinions expressed by DZone contributors are their own.