A big difference is that LTRIM and RTRIM will remove Control characters that aren't visible while the TRIM function will not. The result is that hidden control characters will remain with the TRIM function and could potentially give you an improper mismatch of values.