What happens to the surrounding spaces?

Question

Accepted Answer

TRIM removes leading and trailing whitespace (spaces) from a string by default. LTRIM removes only leading whitespace; RTRIM removes only trailing whitespace. TRIM can also remove specific characters: TRIM('x' FROM 'xxhelloxx') returns 'hello'.