What output does the RIGHT function provide?

• A. Returns a specified number of characters from the left side of a string
• B. Returns a specified number of characters from the right side of a string
• C. Returns a complete string without modification
• D. Finds and replaces a character in a string

Answer: (B)

The RIGHT function is designed to extract a specified number of characters from the right side of a given string. When utilizing this function, you provide it with a string and the number of characters you wish to retrieve starting from the end of that string.

For example, if you have the string "Kinaxis" and use the RIGHT function to extract 3 characters, the result would be "xis". This behavior is particularly useful when you only need the trailing characters of a string for operations such as formatting, substrings extraction, or data manipulation where the right-most characters carry specific significance.

Other options describe different string manipulation functions: extracting from the left, returning the whole string untouched, or performing substitutions within the string—none of which align with the functionality of the RIGHT function.