LTRIM(str)
: Removes all white spaces from the beginning of the string.
RTRIM(str)
: Removes all white spaces at the end of the string.
Example 1:
SELECT TRIM(' Sample ');
Result: 'Sample'
Example 2:
SELECT LTRIM(' Sample ');
Result: 'Sample '
Example 3:
SELECT RTRIM(' Sample ');
Result: ' Sample'