Example
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.
Syntax
TRIM([
characters
FROM
]
string
)Parameter Values
| Parameter | Description |
|---|---|
| characters FROM | Optional. Specific characters to remove |
| string | Required. The string to remove spaces or characters from |
Technical Details
| Works in: | SQL Server (starting with 2017), Azure SQL Database, |
|---|