Trim()

A small curiosity…

The TRIM() function in Excel works completely differently than TRIM in SQL. In Excel, it removes all occurrences of spaces except for a single occurrence between words, while in SQL it removes only spaces from the beginning and end of a string.