RIGHT('Hello World', 5) as column
RIGHT('Hello World', 20) as column
RIGHT('Hello World', 0) as column
RIGHT('', 5) as column
LEFT('Hello World', 5) as column
LEFT('Hello World', 20) as column
LEFT('Hello World', 0) as column
LEFT('', 5) as column
ASCII('hello') as column
LOCATE('world', 'helloworld') as column
LOCATE('world', 'hello') as column
LOCATE('world', 'helloworld', 7) as column
REPLACE('helloworld', 'world', 'opensearch') as column
REPLACE('hello', 'world', 'opensearch') as column
CONCAT('hello', 'world') as column
CONCAT('hello ', 'whole ', 'world', '!') as column