Name

LTRIM() and RTRIM()

Synopsis

LTRIM(str) and RTRIM(str)

The function LTRIM returns the string str with any leading spaces removed, while the function RTRIM performs the same action on the string’s tail. This code returns the strings “No Padding” and “No Padding”:

SELECT LTRIM('   No Padding   ');
SELECT RTRIM('   No Padding   ');