RTRIM

Search:

 

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