SQL Scriptshttp://2pttechnology.com/web/forums/15/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.2)How to remove carriage return from a record SQLhttp://2pttechnology.com/web/forums/thread/205.aspxWed, 04 Mar 2009 01:19:37 GMTa285717b-1f26-4449-a706-ef28376a7378:205twaligora0http://2pttechnology.com/web/forums/thread/205.aspxhttp://2pttechnology.com/web/forums/commentrss.aspx?SectionID=15&PostID=205<FONT color=#0000ff size=2><FONT color=#0000ff size=2> <P><FONT color=#808080>it appears that</FONT> char</FONT></FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>(</FONT></FONT><FONT size=2>10</FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>) holds the value of a carriage return so</FONT></FONT></P> <P><FONT color=#808080 size=2></FONT>&nbsp;</P><FONT size=2><FONT color=#808080><FONT color=#0000ff size=2><FONT color=#0000ff size=2> <P>select</FONT></FONT><FONT size=2><FONT color=#000000> </FONT></P> <P></FONT><FONT color=#ff00ff size=2><FONT color=#ff00ff size=2>&nbsp;&nbsp;&nbsp;replace</FONT></FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>(</FONT></FONT><FONT color=#ff00ff size=2><FONT color=#ff00ff size=2>ISNULL</FONT></FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>(</FONT></FONT><FONT size=2>MyValue</FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>,</FONT></FONT><FONT color=#ff0000 size=2><FONT color=#ff0000 size=2>''</FONT></FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>),</FONT></FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>char</FONT></FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>(</FONT></FONT><FONT size=2>10</FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>),</FONT></FONT><FONT color=#ff0000 size=2><FONT color=#ff0000 size=2>' '</FONT></FONT><FONT color=#808080 size=2><FONT color=#808080 size=2>)</P></FONT></FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2> <P>from</FONT></FONT><FONT size=2><FONT color=#000000> </FONT></P> <P>&nbsp;&nbsp;&nbsp;MyTable&nbsp;</FONT><FONT color=#808080 size=2><FONT color=#808080 size=2></P></FONT></FONT></FONT></FONT>