Limitación de responsabilidad por el uso del Traductor Google. Haga clic aquí .
LTRIM Function
The LTRIM function removes leading spaces (i.e. those to the left) from any variable to which it is applied (i.e. text string, database field, etc.)
Syntax
LTRIM(expression)
Expression
Text String
- Example
LTRIM("TEST")
Returns "TEST" with the spaces to the left trimmed from the string.
Database Field
To use a database field with LTRIM function, apply the following expression: (DATABASE -> FIELD)OPERATORVALUE
-
Example 1
LTRIM(AM->AC_NO)="108"
Returns only records with account number 108.
-
Example 2
(LEFT(LTRIM(AM->AC_NO),2)="11"
Returns only accounts that start with "11" (i.e. 11, 110, 111, 112, ..., 1100, 1101, 1102, ..., etc.). Similar to using a wildcard grouping mask 11??.