SQL Server TRIM() Function
Multi tool use
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
SQL Server TRIM() Function
❮ SQL Server Functions
Example
Remove leading and trailing spaces from a string:
SELECT TRIM(' SQL Tutorial! ') AS TrimmedString;Try it Yourself »
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, |
|---|
More Examples
Example
Remove characters and spaces from a string:
SELECT TRIM('#! ' FROM ' #SQL Tutorial! ') AS
TrimmedString;Try it Yourself »
❮ SQL Server Functions
