SQL Academy · Lesson

TRIM, LPAD, RPAD

Clean whitespace with TRIM/LTRIM/RTRIM and pad fixed-width identifiers with LPAD and RPAD.

TRIM: Remove Padding

Strip leading and trailing whitespace by default:

SELECT TRIM('   hello   ');     -- 'hello'
SELECT LTRIM('   hello   ');    -- 'hello   '
SELECT RTRIM('   hello   ');    -- '   hello'

Strip arbitrary characters:

SELECT TRIM(BOTH '0' FROM '0001230');   -- '123'
SELECT TRIM(LEADING '#' FROM '#hashtag'); -- 'hashtag'