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.