Cacher is the code snippet organizer for pro developers

SELECT ID
	,PGU
	,Product_Mapping Skill
	,Complexity	
	--,REPLACE(REPLACE(REPLACE(REPLACE(Questions, CHAR(13) + CHAR(10), ' ... '), CHAR(10) + CHAR(13), ' ... '), CHAR(13), ' '), CHAR(10), ' ... ') Questions
	,replace( replace( replace( replace( replace(Questions,'<',''),'br/',''),'>','') ,CHAR(13),''),CHAR(10),'') Questions
	,replace(replace( replace( replace( replace(AnswerA,'<',''),'br/',''),'>',''),CHAR(13),''),CHAR(10),'')  AnswerA
	,replace(replace( replace( replace( replace(AnswerB,'<',''),'br/',''),'>',''),CHAR(13),'') ,CHAR(10),'') AnswerB
	,replace(replace( replace( replace( replace(AnswerC,'<',''),'br/',''),'>',''),CHAR(13),''),CHAR(10),'')  AnswerC
	,replace(replace( replace( replace( replace(AnswerD,'<',''),'br/',''),'>',''),CHAR(13),'') ,CHAR(10),'') AnswerD
	,Correct_Answer
	,Question_Type
	,Answer_type
	,category
	,Trainer Contributor
	,Reviewed
	,L1_Approval_Status
	,L1_Date
	,Center
	,Location
	,reviewer_comments
	,Contributed_Date
FROM questions_raw_new
WHERE Product_Mapping IN (
		'TAM'
		,'TAM-HPSD'
		,'TAM-Server'
		)
	AND Reviewed = 'Yes'
ORDER BY PGU
	,Product_Mapping
	,Complexity