Inserting Line Breaks Into Db Field

I have a field in a db table which is like a chat history.
I need to update the field with a user's input (put into a multiline text box) and append that to the beginning of the field.

The problem is that I want to maintain line breaks when I retrieve the field into a multiline textbox (aka textarea) and can't figure it out.
I've searched around and have seen lots of solutions for converting line breaks into <br> tags, but those people are trying to output to a label.
I'm using an update command in my SqlDataSource like this:
    UpdateCommand="UPDATE [account] SET [history] = @history + history WHERE [id] = 1"
With a parameter declaration like this: 
    <UpdateParameters>
        <asp:ControlParameter Name="history" ControlID="TextBox1" PropertyName="Text" />
    </UpdateParameters>
If I try to concatenate in a
or CHR(10), the characters are literally inserted.  Like this for example (this is the last variation I tried)....
    UpdateCommand="UPDATE [account] SET [history] = @history + CHR(10) + history WHERE [id] = 1"
How do I store a CrLf programatically?