LTRIM()

Description

This function LTRIM() returns the string with leading space characters removed.

Syntax

  1. > LTRIM(str)

Arguments

ArgumentsDescription
strRequired. CHAR and VARCHAR both are supported.

Examples

  1. > drop table if exists t1;
  2. > create table t1(a char(8),b varchar(10));
  3. > insert into t1 values(' matrix',' matrixone');
  4. > select ltrim(a),ltrim(b) from t1;
  5. +----------+-----------+
  6. | ltrim(a) | ltrim(b) |
  7. +----------+-----------+
  8. | matrix | matrixone |
  9. +----------+-----------+

Constraints

Currently, MatrixOne doesn’t support select function() without from tables.