InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 07:00:00 GMT20http://www.sqlservercentral.com/Forums/Topic1381732-392-1.aspxYes, thank youThat worked perfectlyThanks again for your assistanceAndrew SQLDBAWed, 07 Nov 2012 08:12:02 GMTAndrewSQLDBAhttp://www.sqlservercentral.com/Forums/Topic1381732-392-1.aspxI went back and revisited this. The code below should work for you. I created a Table with a Column in it. Added text that ended with ' ||' and then ran this against it.[code="sql"]UPDATE [dbo].[Table1] SET [Col3] = (SELECT SUBSTRING(Col3, 1, + CHARINDEX(' ||',Col3, -1)))GO[/code]Good luck.Wed, 07 Nov 2012 08:07:53 GMTkyleswayhttp://www.sqlservercentral.com/Forums/Topic1381732-392-1.aspxHi,Can you not add a update statement at the end of the package, which update all that column and removes any pipeline characters?[code="other"]update yourtablenameset yourcolumnname = REPLACE(<columnname>,char(124),char(32))[/code]Tue, 06 Nov 2012 16:26:23 GMTSQL_Killshttp://www.sqlservercentral.com/Forums/Topic1381732-392-1.aspxYou could try altering the 'raw' data. If this is in txt form (or is you can get it there), you could use a Ctrl + H (Find and Replace). Then try your import. That may work. Do you have that option?Tue, 06 Nov 2012 15:37:51 GMTkyleswayhttp://www.sqlservercentral.com/Forums/Topic1381732-392-1.aspxHello EveryoneI am loading some data, not clean and not from another SQL source. So there are all kinds of things mixed in the data.At the very end of each row in the table, in the very last column, I have a blank space followed by two pipes ( ||). I need to delete the blank space and the two pipe, but none of the data in front of that in the same column. Each row is different for that particular column. But this odd charachter mix is always at the very end.How can I most efficiently delete the blank space and the two pipesThank you in advance for you helpAndrew SQLDBATue, 06 Nov 2012 15:29:18 GMTAndrewSQLDBA