SQL Server TRIM() Function

Remove leading and trailing spaces from a string:

SELECT TRIM(' SQL Tutorial! ') AS TrimmedString;

Definition and Usage

The TRIM() function removes the space character OR other specified characters from the start or end of a string.

By default, the TRIM() function removes leading and trailing spaces from a string.

Note: Also look at the LTRIM() and RTRIM() functions.

TRIM([ characters FROM ] string)

Parameter	Description
characters FROM	Optional. Specific characters to remove
string	Required. The string to remove spaces or characters from

Works in:	SQL Server (starting with 2017), Azure SQL Database,

Remove characters and spaces from a string:

SELECT TRIM('#! ' FROM ' #SQL Tutorial! ') AS TrimmedString;