I did what you said and used the following code to do it and it works great.
In ASP when accessing the data from the record set I used the Replace function as shown below to parse out and replace the data before displaying it.

Replace(oRs("txtNote"),chr(13),"
")

Thanks.