T-SQL TRIM() Function
The T-SQL (Transact-SQL) TRIM() function removes all specified characters from the beginning and the end of the given string.
Syntax
TRIM( [ characters FROM ] string)
Parameters
characters |
Optional. Specify the characters to be trimmed from string. If omitted, spaces will be removed. |
string |
Required. Specify the string to trim. |
Return Value
Returns the trimmed version of the specified string.
Example 1:
The example below shows the usage of TRIM() function.
SELECT TRIM(' SQL Tutorial '); Result: 'SQL Tutorial' SELECT TRIM(' ' FROM ' SQL Tutorial '); Result: 'SQL Tutorial ' SELECT TRIM('0' FROM '000123'); Result: '123' SELECT TRIM('1' FROM 'John1'); Result: 'John' SELECT TRIM('123' FROM 'John123'); Result: 'John' SELECT TRIM('321' FROM '123John123'); Result: 'John'
Example 2:
Consider a database table called Employee. When the following INSERT statements are executed, the Name column will contain records with leading and trailing spaces.
INSERT INTO Employee VALUES (' John ', 'London', 3000); INSERT INTO Employee VALUES (' Marry ', 'New York', 2750); INSERT INTO Employee VALUES (' Jo ', 'Paris', 2800); INSERT INTO Employee VALUES (' Kim ', 'Amsterdam', 3100); -- see the result SELECT * FROM Employee;
The query will produce the following result:
Name | City | Salary |
---|---|---|
John | London | 3000 |
Marry | New York | 2750 |
Jo | Paris | 2800 |
Kim | Amsterdam | 3100 |
To remove the leading and trailing spaces from the Name column of the Employee table, the following query can be used:
UPDATE Employee SET Name = TRIM(Name); -- see the result SELECT * FROM Employee;
This will produce the following result:
Name | City | Salary |
---|---|---|
John | London | 3000 |
Marry | New York | 2750 |
Jo | Paris | 2800 |
Kim | Amsterdam | 3100 |
❮ T-SQL Functions