To remove extra spaces to the right of a value after concatenating two or more columns, use the _____.
A) TRUNCATE function
B) TRIM function
C) FLOOR function
D) RTRIM function

Question

Quizplus · Accepted Answer

The RTRIM function is used to remove any extra spaces to the right of a value, which is useful after concatenating two or more columns to ensure the resulting string does not end with unnecessary whitespace.

To Remove Extra Spaces to the Right of a Value