Specifies how to trim the specified trim character or byte from string_expression.
- BOTH means trim both trailing and leading characters or bytes.
- TRAILING means trim only trailing characters or bytes.
- LEADING mens trim only leading characters or bytes.
If you omit this option, the default is BOTH, and the default trim character is a null byte for byte types and a pad character for character types.