I am creating a user forum, much like these ones. I am having a little problem though.

When you type in your reply or new post, the newlines get lost when saving the text to the db (SQL Server 2000, text field). I want to be able to insert <br> tags for the newlines, but don't know how to go about it. Any suggestions?

Example of what I mean:
The empty lines between the paragraphs in this post, they don't show up when I save them to the db in my forums.