In classic ASP, I was able to use this VB code to find carriage returns in SQL query results and add them as Line Breaks to displayed text.
<% Dim Notes
Notes = escape(WorkOrderDetails.Fields.Item("note_text").Value)
Notes = Replace(Notes, "%0D", "<br>")
Notes = unescape(Notes) %>