JavaScript Editor js editor     Web development 



Main Page

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

See Also



JavaScript Editor js editor     Web development