Sometimes special characters in varchar field are the reason why after exporting data into excel - it is not properly formatted (part of the record is moved to the new line)
- to resolve - simple exclude these characters while querying the database
REPLACE(REPLACE(REPLACE(FieldName, CHAR(10), ''), CHAR(13), ''), CHAR(9), '') AS [FieldName]
No comments:
Post a Comment