REVERSE()

    2. > create table t1(a varchar(12),c char(30));
    3. > insert into t1 values('sdfad  ','2022-02-02 22:22:22');
    4. > insert into t1 values('  sdfad  ','2022-02-02 22:22:22');
    5. > insert into t1 values('adsf  sdfad','2022-02-02 22:22:22');
    6. > insert into t1 values('    sdfad','2022-02-02 22:22:22');
    7. +-------------+---------------------+
    8. | reverse(a)  | reverse(c)          |
    9. +-------------+---------------------+
    11. |   dafds     | 22:22:22 20-20-2202 |
    12. | dafds  fsda | 22:22:22 20-20-2202 |
    13. | dafds       | 22:22:22 20-20-2202 |
    14. +-------------+---------------------+
    15. > select a from t1 where reverse(a) like 'daf%';
    16. +-------------+
    17. | a           |
    18. | adsf  sdfad |
    20. +-------------+
    21. > select reverse(a) reversea,reverse(reverse(a)) normala from t1;
    22. +-------------+-------------+
    23. | reversea    | normala     |
    24. +-------------+-------------+
    25. |   dafds     | sdfad       |
    26. |   dafds     |   sdfad     |
    27. | dafds  fsda | adsf  sdfad |
    28. | dafds       |     sdfad   |

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