Hello, I have tried my best to understand your code and come up with a solution which should work. I used xml path and few string manipulation.

Note: I could not test my sql due to the lack of test data. In future, it will be good if you include one.

-- Please provide a valid bid id

DECLARE @bid_Id UNIQUEIDENTIFIER = '????????????????????????????????????' ;

;WITH xmlListCTE(Value) AS

(

SELECT Value = LTRIM(RTRIM(bidC.CRITERIA_NAME)) + ' - ' + CONVERT(VARCHAR(10), bidC.Calc_Points) + '/' + CONVERT(VARCHAR(10), bidC.Max_points)

FROM [dbo].[vw_Bid_Criterias] bidC

WHERE bidC.BID_ID = @bid_Id

ORDER BY bidC.CRITERIA_NUMBER

FOR XML PATH ('')

)

SELECT Result = ISNULL(REPLACE(REPLACE(REPLACE(cte.Value, '</Value><Value>', CHAR(13)), '</Value>', ''), '<Value>', ''), '')

FROM xmlListCTE cte ;