Another question from a newbie

[Joe Horn]

There is a misunderstanding here of what the second argument means. It is not a pointer to a position within the string, but a count of how many characters should be returned, with the counting starting from the right end of the input string.

RIGHT("abcdefg",2) returns "fg" because those are the rightmost two character of the input string.

RIGHT("MOMOGUMBO",5) returns "GUMBO" not because 5 points to the 5th character in the input, but because "GUMBO" is the rightmost 5 characters of the input.

And that's why
RIGHT("MOMOGUMBO",1) returns "O", and
RIGHT("MOMOGUMBO",2) returns "BO", and so on.
RIGHT("MOMOGUMBO",9) returns all 9 characters of the input, as it should.