JavaScript Editor js editor     Web development 

Main Page

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 [, ...]]])



Specifies an expression of Character or Varbinary type to remove all trailing spaces or 0 bytes from, respectively.

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.


TRIM(В ) is identical to RTRIM(В ).


В Copy Code
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE customer  && Opens Customer table
? 'The contact for '+ TRIM(company) + ' is ' + contact

See Also

JavaScript Editor js editor     Web development