Use the vbScript Replace function to replace it with an empty string before you save it to your database.

sComment = Replace(sComment,Chr(13)+CHR(10),"")



>Hello
>
> when i use the Text Area control from visual interdev in an ASP page. and then when i use the page. and i enter multiple line data into the text area without pressing on enter key then its no problem.
>
>But then when i press the enter key in the text area to enter a multiple line text. Then the newline character gets stored in the database and i have problems retrieving that particular data from the database.
>
>Is there a solution to this problem?
>
>Thanks