RPAD()

    2. > CREATE TABLE t1(Student_id INT,Student_name VARCHAR(100),Student_Class CHAR(20));
    3. > INSERT INTO t1
    4. VALUES
    5. (1,'Ananya Majumdar', 'IX'),
    6. (2,'Anushka Samanta', 'X'),
    7. (3,'Aniket Sharma', 'XI'),
    8. (4,'Anik Das', 'X'),
    9. (5,'Riya Jain', 'IX'),
    10. (6,'Tapan Samanta', 'X');
    11. > SELECT Student_id, Student_name,RPAD(Student_Class, 10, ' _') AS LeftPaddedString FROM t1;
    12. +------------+-----------------+------------------+
    13. | Student_id | Student_name    | LeftPaddedString |
    14. +------------+-----------------+------------------+
    15. |          2 | Anushka Samanta | X _ _ _ _        |
    16. |          3 | Aniket Sharma   | XI _ _ _ _       |
    17. |          4 | Anik Das        | X _ _ _ _        |
    19. |          6 | Tapan Samanta   | X _ _ _ _        |
    20. +------------+-----------------+------------------+
    21. > SELECT Student_id, rpad(Student_name,4,'new') AS LeftPaddedString FROM t1;
    22. +------------+------------------+
    23. | Student_id | LeftPaddedString |
    24. +------------+------------------+
    25. |          1 | Anan             |
    26. |          2 | Anus             |
    27. |          3 | Anik             |
    28. |          4 | Anik             |
    29. |          5 | Riya             |
    30. |          6 | Tapa             |
    31. +------------+------------------+
    32. > SELECT Student_id, rpad(Student_name,-4,'new') AS LeftPaddedString FROM t1;
    33. +------------+------------------+
    34. +------------+------------------+
    36. |          2 | NULL             |
    37. |          3 | NULL             |
    38. |          4 | NULL             |
    39. |          5 | NULL             |
    40. |          6 | NULL             |
    41. +------------+------------------+
    42. > SELECT Student_id, rpad(Student_name,0,'new') AS LeftPaddedString FROM t1;
    43. +------------+------------------+
    44. | Student_id | LeftPaddedString |
    45. +------------+------------------+
    46. |          1 |                  |
    47. |          2 |                  |
    48. |          3 |                  |
    49. |          4 |                  |
    50. |          5 |                  |
    51. |          6 |                  |
    52. +------------+------------------+

    MatrixOne目前只支持在查询表的时候使用函数，不支持单独使用函数。