N/APosted on - 04/25/2013
I pasted a DAT file from an SQL database to Excel and I noticed with an empty column which I think are white spaces. Do I need an SQL query whitespace remover tool to remove the white spaces? Any suggestions would be much appreciated. Thanks in advance.
Do i need Sql query whitespace remover tool?
The problem can be solved with the trim function, which will remove white spaces. Please follow the below mentioned procedure: Select the function TRIM (field name), LTRIM (field name), R TRIM (field name), LTRIM (RTRIM (field name)) from table name.
Follow this link for more details description about the removal of white space.
Mentionable that, you don't need to install a separate software to do this.