TRIM
SELECT LENGTH(' text ') length, LENGTH(TRIM(' text ')) length_with_trim
Pro tip: use ```triple backticks around text``` to write in code fences