Removes all leading spaces or parsing characters from the specified character expression, or all leading zero (0) bytes from the specified binary expression.
LTRIM(Expression [, nFlags] [, cParseChar [, cParseChar2 [, ...]]]) |
Parameters
- Expression
- Specifies an expression of Character or Varbinary type to remove leading spaces or 0 bytes from, respectively.
- nFlags
- Specifies if trimming is case-sensitive when one or more parse characters (cParseChar, cParseChar2, … are included. Trimming is case-sensitive if nFlags is zero or is omitted. Trimming is case-insensitive if nFlags 1.
- cParseChar [, cParseChar2 [, ...]]
- Specifies one or more character strings that are trimmed from the beginning of cExpression. If cParseChar isn't included, then leading spaces or 0 bytes are removed from Expression. NoteВ В В The maximum number of strings permitted in cParseChar is 23.
Return Value
Character or Varbinary. LTRIM(В ) returns the specified expression without leading spaces or parsing characters, or 0 bytes.
Remarks
LTRIM(В ) is particularly useful for removing the leading spaces that are inserted when you use the STR(В ) function to convert a Numeric value to a Character string.
Example
В | Copy Code |
---|---|
STORE 'Redmond' TO gcCity STORE ' Washington' TO gcState CLEAR ? gcCity, gcState && Displays Redmond Washington ? gcCity, LTRIM(gcState) && Displays Redmond Washington |