SQLServerCentral / SQL Server 2005 / Development / Removing trailing spaces in a table column / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 20:22:21 GMT20RE: Removing trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxI used following to remove only trailing white spaces in a CHAR(30) column:RTRIM(LTRIM(CAST(City_Id As VARCHAR(30)))) AS City_IdPiyush VarmaWed, 03 Oct 2012 12:49:00 GMTpiyush.varmaRE: Removing trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxSELECT ASCII(SUBSTRING(Col1, n, 1))Tue, 14 Jun 2011 10:05:55 GMTSwePesoRE: Removing trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxCan you advise as to how you fixed the issue and how you knew it was a CR/LF. We are having the same issue when loading mainframe data into our systems and an RTRIM is not working. Thanks.Tue, 14 Jun 2011 09:44:55 GMTbwielandRE: Removing trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxHi ,Fixed the issue :-) , the trailing space was in fact a carriage return , ascci value (13) , used a replace(queryphrase,char(13),'') to fix the issue .Guess where i went wrong was assuming there could only be spaces in the column.JayTue, 22 Jan 2008 04:20:57 GMTJayanth_KurupRE: Removing trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxLEN() function is NOT counting trailing spaces.DATALENGTH() does.Are you the spaces really are spaces (ascii value 32)?Make sure they are not hard-spaces (ascii value 160).Tue, 22 Jan 2008 02:56:53 GMTSwePesoRE: Removing trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxCheck the following link may be usefulhttp://www.thescripts.com/forum/thread162850.htmlTue, 22 Jan 2008 02:53:03 GMTvyasRemoving trailing spaces in a table columnhttp://www.sqlservercentral.com/Forums/Topic445783-145-1.aspxHi I am having trouble removing trailing spaces in a table column (query phrase).so far i have tried using Ltrim , rtrim but no luck , i have used len and substring as well . funny thing is when using len(queryphrase) its counting the trailing space.also an update with replace dosen't work I have set the table with ansi padding off and have used both nvarchar and char columns to see if it made any difference , but no luck there either.Are there any other options available ???Thanks in advance:-)Tue, 22 Jan 2008 02:43:50 GMTJayanth_Kurup