Menu

Want to work with us? We're on the lookout for a talented Digital Project Manager.

We're hiring

Square Box In SQL Problem - Carriage Return

Web Bureau


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.

Grow your businessStart a project with us today.