LTRIM vs RTRIM

Question

LTRIM vs RTRIM

Accepted Answer

LTRIM removes only the leading (left-side) whitespace and leaves trailing spaces intact. The result is 'hello  ' - two trailing spaces remain. Compare: RTRIM('  hello  ') returns '  hello' (only trailing spaces removed), and TRIM removes both sides. These functions are useful when your data has inconsistent padding on just one side.