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.

RTRIM(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. RTRIM(В ) returns the specified expression without trailing spaces or parsing characters, or 0 bytes.

Remarks

You can use RTRIM(В ) to ensure that trailing spaces or leading and trailing zero (0) bytes are removed from data entered by a user. RTRIM(В ) is identical to TRIM(В ).

Example

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

See Also



JavaScript Editor js editor     Web development 
R7