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

Remarks

Example

	Copy Code
STORE 'Redmond' TO gcCity STORE ' Washington' TO gcState CLEAR ? gcCity, gcState && Displays Redmond Washington ? gcCity, LTRIM(gcState) && Displays Redmond Washington

See Also