DB2 Scalar functions - LTRIM (SYSFUN schema)


Volta a página anterior

Volta ao Menu das scalar functions

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

LTRIM (SYSFUN schema)

Returns the characters of the argument with leading blanks removed.

LTRIM(expression)

The schema is SYSFUN.

expression
An expression that returns the built-in character string or Boolean value that is to be trimmed.
The maximum length is:
  • 4000 bytes for a VARCHAR
  • 1,048,576 bytes for a CLOB

Result

The data type of the result is:

  • VARCHAR(4000) if the data type of the expression is CHAR or VARCHAR
  • CLOB(1M) if the data type of the expression is CLOB or LONG VARCHAR

The result can be null; if the expression is null, the result is the null value.


© Copyright IBM Corp.