LTRIM()

Description

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

Syntax

1. > LTRIM(str)

Arguments

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;

6. +----------+-----------+
7. | ltrim(a) | ltrim(b)  |
8. +----------+-----------+
9. | matrix   | matrixone |
10. +----------+-----------+

Constraints

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