I'm using SQL Assistant to output the results from a query to a file. Is there an option in SQL Assistant to trim the leading and trailing blanks when sending the SQL results to a file? I was hoping to accomplish this without coding a trim function to every field.
I feel simply using "Select Trim(Column) From Table" will give desired result.
This will remove leading & trailing blank spaces from the applied column.