LTRIM

 

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

SQL Syntax:
 
   LTRIM( 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 LTRIM( expression ) }
Return Type:
 
  A character string or binary data type depending of the data type of the expression.

Examples:

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

    Return Values: ;Peter ;

see also:
SQL String Functions
RTRIM


100% pure Java DBMS
Mirror Site