Trims spaces from the start and end of a string value.
- * expression: a character expression of one of these types, or an expression that resolves to one of these types:
- LONG VARCHAR
The same type as the input expression.
NULL if expression evaluates to NULL.
SELECT firstName, TRIM(firstName) AS firstNameTrim FROM MYSQL.inventory.cust; VALUES TRIM(' John Smith '); -- Returns John Smith