Home Forums SQL Server 2005 T-SQL (SS2K5) char(10) and char(13) RE: char(10) and char(13)

  • November 6, 2014 at 11:29 am

    #1757067

    Using:

    replace( replace(CAST(FieldName AS NVarchar(MAX)), char(13), ''), char(10), '')

    Still experiencing column alignment issues when exporting to excel (?) Please what format can I use to avoid this?