Description
Removes leading and trailing spaces from a string field.
Syntax
TRIM(string_expression)
Examples
TRIM(' John Smith ')
returns 'John Smith'
Return value datatype
String
Impact of null value
If input is null, returns null.
Removes leading and trailing spaces from a string field.
TRIM(string_expression)
TRIM(' John Smith ')
returns 'John Smith'
String
If input is null, returns null.
Free 7-day trial. Easy setup. Cancel any time