How to Use the SQL TRIM Function to Remove Spaces

Databases often contain unwanted leading and trailing spaces or other characters around a data string. If these aren’t removed or trimmed, the data will return incorrect matches for queries with WHERE and other clauses. The SQL TRIM function is one of the most frequently used SQL operations for trimming string type data. It removes all spaces and other specified characters from a text string except for the single spaces between words. 

However, in SQL Server and other Relational Database Management Systems (RDBMs), this function may require some refinement to ensure it returns the desired results. Here’s a look at how the TRIM function works in SQL Server, Oracle, and other databases to remove irregular spacing and inappropriate characters from data strings and tables.

If you don’t have SQL Server, you can install SQL Server Developer edition for free. Just follow the link for more details.

Using the SQL TRIM Function in Relational Database Management Systems

SQL is the industry standard programming language for querying relational databases. It is the language behind today’s most widely used RDBMs. These systems collect and manage data from different sources, but that data can arrive with formatting issues, such as irregular spacing and inappropriate characters.

Recommended Learning Platform course

70-461, 761: Querying Microsoft SQL Server with T-SQL course

Phillip Burton • over one million students so far, I Do Data Limited