12 June 2012 by Web Bureau
Had a bit of an issue the other day with an erroneous square box appearing in SQL Server as user had input a carriage return or some other witchcraft.
Anyway the simple solution when writing to a .csv was a select from SQLthat replaced the column ie. Replace (ColumnName , CHAR(10), '')
Not the ideal solution as we should have parsed input but couldnt find a .Net solution that was suitable - will keep you posted and will update when i know more.