newline character in sqlserver

what is the newline character in sqlserver.
My problem is ,I have to display text (say "Hi \n abcd\n hhh\n") where \n is the newline.
But when i print this in sqlserver storedproc,Its displaying as it is instead of newlines.

please help

thxyou can do it via asp.net when you pass in the string do a string.replace of newlines ..something like

txtstmtbdy.text.replace(environment.newline,"<br>")

and when you display it the html is automatically parsed by the browser..so you dont have to worry about messing with it in sql server.

hth|||I assume you mean displaying the results in Query Analyser? If so I believe its the good old fashioned ASCII 10+13