How to store carriage return in SQL
Posted on 2008-10-15
There is an address list that is kept in Excel 2003 with 3 Columns ( Name, CompName, CompAddress). I am building a web-app that will allow users to edit the maililng list. First step was to bring the data into MSSQL 2008. No biggie. Except, in the CompAddress field, the originator had used carriage returns in order to format so she could do a mail merge in word and the address would be formatted correctly.
On SQL server in the ComAddress field after the import I see a "square" (assuming it always shows the for special characters). My problem is, how do I store that special character? I was hoping to just have a method that is an insert/update, just don't know how to store that same special character.
In excel she said she uses the Alt-Enter to get carriage return inside a cell.
I am open to Suggestions on solving differently.