SELECT Result.IdNum AS [Trans #],
       Result.VerifyDate AS [Date Verified],
       Exam.XRayExam AS [Exam Description],
       RadiologistName AS Radiologist,
       Interpretation,
       REPLACE(SUBSTRING(InterpretationPureText, 1, DATALENGTH(InterpretationPureText)), CHAR(10), '<br />') AS InterpretationText,
       RequestNum
FROM Radiology..tbxrResult AS Result
     LEFT OUTER JOIN Build_File.dbo.tbCoXrayExam AS Exam ON Result.ItemCode = Exam.XRayExamID
WHERE Result.HospNum = '400885'
  AND Result.IDNum = '674896'
  AND VerifyById IS NOT NULL
ORDER BY Result.TransDate DESC;