Is there a way to add line breaks to result set column names so when I copy the results with headers to excel, the column names are already have any line breaks that I need them to have.
I know that I can write a query like this: Select EmpVal16 As 'Clock Number' From EmpView to change the output query column name from EmpVal16 to Clock Number. It would be really nice if I could do something like ClockNumber so that it would automatically make the column heading on two lines in Excel. Is this possible? Otherwise, I know I can use ALT-ENTER in Excel to add a line break, but it is a hassle if you have several columns.