LTRIM() & RTRIM() Functions:

We have pre-defined trim funcations in SQL inorder to remove blank spaces in text. LTRIM() funcation removes the blank spaces from left side and RTRIM() function removes the blank spaces from right side. Both the two funcations expect string as parameter.

LTRIM ( character_expression ), RTRIM(character_expression)