RTRIM

 

The function RTRIM removes the leading blank character from the expression.

SQL Syntax:
 
   RTRIM( expression )
Parameters:
 
  expression

Any data type of expressions. If it isn't a binary type then it will convert first to a string data type.

Escape Syntax:
 
  {fn RTRIM( expression ) }
Return Type:
 
  A character string or binary data type depending of the data type of the expression.

Examples:

  • SELECT ';' + RTRIM( ' Peter ' ) + ';'

    Return Values: ; Peter;

see also:
SQL String Functions
LTRIM


100% pure Java DBMS
Mirror Site