SQL: How to Remove all Spaces From a Column

With the replace command you can easily replace any data in a column. In this case I am using it to remove all spaces.

Useful when data looks like this “xxx xx  xxx  x”

 

Leave a Reply

Your email address will not be published. Required fields are marked *