Removes all trailing spaces or parsing characters from the specified character expression, or all trailing zero (0) bytes from the specified binary expression.
TRIM(cExpression [, nFlags] [, cParseChar [, cParseChar2 [, ...]]]) |
Parameters
- cExpression
- Specifies an expression of Character or Varbinary type to remove all trailing spaces or 0 bytes from, respectively.
- nFlags
- Specifies if trimming is case-sensitive when one or more parse characters (cParseChar, cParseChar2, … are included. Trimming is case-sensitive if nFlags is zero or is omitted. Trimming is case-insensitive if nFlags 1.
- cParseChar [, cParseChar2 [, ...]]
- Specifies one or more character strings that are trimmed from the end of cExpression. If cParseChar isn't included, then trailing spaces or 0 bytes are removed from Expression. NoteВ В В The maximum number of strings permitted in cParseChar is 23.
Return Value
Character or Varbinary. TRIM(В ) returns the specified expression without trailing spaces or parsing characters, or 0 bytes.
Remarks
TRIM(В ) is identical to RTRIM(В ).
Example
В | Copy Code |
---|---|
CLOSE DATABASES OPEN DATABASE (HOME(2) + 'Data\testdata') USE customer && Opens Customer table CLEAR ? 'The contact for '+ TRIM(company) + ' is ' + contact |