Want to work with us? We're on the lookout for digital experts.

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.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.