Do i need Sql query whitespace remover tool?

Asked By 40 points N/A Posted on -
qa-featured

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.

SHARE
Answered By 40 points N/A #142880

Do i need Sql query whitespace remover tool?

qa-featured

 Hi,

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.

Related Questions