Trimming spaces from fields

Tools
Enthusiast

Trimming spaces from fields

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.    

Thanks, Mark

1 REPLY
Enthusiast

Re: Trimming spaces from fields

Hello.

I feel simply using "Select Trim(Column) From Table" will give desired result.

This will remove leading & trailing blank spaces from the applied column.

Thanks