Do i need Sql query whitespace remover tool?

Asked By 40 points N/A Posted on -

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.

Answered By 40 points N/A #142880

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.

Login/Register to Answer

Related Questions