I'm trying to read text from an SQL table that was entered with Access with Formating.

How do i read it back via asp vbscript to include the formatting, currently i'm just getting it as one long string.

Example:

i get

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaa 1.aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa2.bbbbbbbbbb 3.ccccccccccccc

I would like to get
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaa
1.aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
2.bbbbbbbbbb
3.cccccccccccccccc

Hope that makes sense
Thanks for any help

Output_String = (all that slop you typed in above)
If Output_String <> "" then
     Output_String = Replace (Output_String, vbCrLf, "<br />") ' This replaces all Visual Basic line feeds with HTML line breaks.
end if
Response.Write Output_String