TRIM
Last updated
Last updated
Returns a character expression without blank spaces (TRIM in Transact-SQL).
TRIM( string_expression )
string_expression:
String expressions to convert.
VARCHAR
or NVARCHAR
Code:
SELECT TRIM(' FIRST AND LAST TWO BLANK SPACES ') AS [TRIM];
Output:
+-------------------------------+
|TRIM |
+-------------------------------+
|FIRST AND LAST TWO BLANK SPACES|
+-------------------------------+