RTRIM
SELECT LENGTH(' text ') length, LENGTH(RTRIM(' text ')) length_with_right_trim
Pro tip: use ```triple backticks around text``` to write in code fences