Do i need Sql query whitespace remover tool?

Asked By elyssaguadalupe 40 points N/A Posted 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.

• Status: Open
• Question Views: 722
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Suggestions

Answered By Reginald E Cosentino 40 points N/A #142880

Do i need Sql query whitespace remover tool?

 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.

About Reginald E Cosentino

Questions
18

Answers
26

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 05/01/2013
• Question Category: Suggestions