Special characters in the database field

Hi,
I hope this is the right place to ask this question. I have SQL server (2000) database table that has encoded email messages. I want to decode this message and present it in plain English. But the problem is the database puts a special character in the end of each line that looks like a bold line. Does anyone know what this character is called and maybe how to replace it with ""? This is messing up my decoding method.

Thanks!

I can think of a couple of approaches. Assuming that the message is just a string of some sort, it should be a matter (maybe) of figuring out what the symbol is and replacing all instances in a string. If you can capture the symbol using cut and paste or something, then it can be replaced in the string easily by using:
mystring.replace(character_to_replace,"");
That would be about the easiest approach I can think of.

Thanks. I'll try to figure out a way to remove all the special characters from the body of the message.

Sangeetha,

It might be an end-of-line character.
Wikipedia has a Newline entry.
Regards, Jan
[ June 14, 2007: Message edited by: Jan Cumps ]