To remove extra spaces to the right of a value,for example,the value in a FIRST_NAME column,use the ____ function.
A)TRUNCATE
B)TRIM
C)RIGHT
D)RTRIM

Question

To remove extra spaces to the right of a value,for example,the value in a FIRST_NAME column,use the ____ function.
A)TRUNCATE
B)​TRIM
C)RIGHT
D)​RTRIM

Quizplus · Accepted Answer

The RTRIM function removes any trailing spaces from a string value, which includes any spaces to the right of the value. TRUNCATE is used to remove decimal points from a numeric value, while TRIM removes both leading and trailing spaces from a string value. RIGHT is used to extract a specific number of characters from the end of a string value.

To Remove Extra Spaces to the Right of a Value,for