SQL RIGHT Function: Understanding 'SELECT RIGHT('LAWSON', 3)'

What is the output of SELECT RIGHT('LAWSON', 3);?

The SQL RIGHT function extracts a specified number of characters from the right side of a string. In this case, SELECT RIGHT('LAWSON', 3) will return the last three characters of the string 'LAWSON'.

Therefore, the correct answer is A. SON

Explanation:

• RIGHT('LAWSON', 3): This part of the query specifies that we want to extract the rightmost 3 characters from the string 'LAWSON'.
• The SELECT statement then retrieves the result of the RIGHT function, which is 'SON' in this instance.

Key Points:

• The RIGHT function is a powerful tool for manipulating string data in SQL.
• It is commonly used to extract specific parts of strings, such as email domains, file extensions, or the last few characters of a code.
• The RIGHT function is similar to the LEFT function, which extracts characters from the left side of a string.