TRIM
Description
Returns a character expression without blank spaces (TRIM in Transact-SQL).
Sample Source Pattern
Syntax
TRIM( string_expression )
Arguments
string_expression:
String expressions to convert.
Return Type
VARCHAR
or NVARCHAR
Examples
SELECT TRIM(' FIRST AND LAST TWO BLANK SPACES ') AS [TRIM]
Last updated
Was this helpful?