I have a MS SQL SERVER query that I run. One of the field/columns is huge. Called Raw_Results If the results are say 1200-1400 characters long and.......
and I need to export them to a file in excel. Current version. How could I do that cleanly.
Why because the results of that column wrap on export. Thus messing up the file because I cant get clean columns.
Is there a way in SQL or EXCEL that might correct that. I heard that there might be a CHAR(??) function or something that might do it or maybe some setting in excel or in the SQL Export tool that can solve this problem?