Converting line breaks to <br>

Hi

This is probably a simple question! I have a field in a database (sql server) which will contain carriage returns. I want to display this field in a web page (asp.net using c#) with the returns. I am trying to do a string replace but am not sure what i am meant to be replacing. I mean, i've tried '\n' but that isnt it.

e.g. - myStr.Replace("\n", "<br>");

So what i want to know is, what character is used in a database to indicate line feed?

Or is there a better way to achieve this that i dont know about?

Thanks for your help and i hope this is a clear enough explanation.

J

Ickle,
Try myStr.Replace("\r\n", "<br>");