LTRIM

4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next

version 11


LTRIM (arithmetic_expression[, arithmetic_expression])

Description

The LTRIM function removes any empty spaces from the beginning of the arithmetic_expression. The optional second arithmetic_expression can be used to indicate specific characters to be removed from the beginningof the first arithmetic_expression.

Example

This example simply removes any empty spaces from the beginning of product names:

   SELECT LTRIM(Name)
   FROM PRODUCTS;

See Also

RTRIM, TRIM.


4D - Documentation   Français   English   German   Japanese   4D SQL Reference, Table of Contents   4D SQL Reference, Index   Back   Previous   Next