LTRIM

Search:

 

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