REVERSE

Reverses the characters of a String.

Example: REVERSE('1234567890') = '0987654321'

REPLACE

The replace function replaces every occurrence of a search_string with a new string. If no new string is specified, all occurrences of the search_string are removed.

Example: replace('a1a1a1','a','2') = '212121'.

LTRIM

LTRIM removed characters from the left of a string if they are equal to the specified string.

Example: ltrim('aaaaaabc','a') = 'bc'

If the last parameter is not specified, spaces are removed from the left side.