TRIM from both sides
SQL> SQL> SQL> SELECT TRIM (both ' ' from ' String with blanks ') FROM dual; TRIM(BOTH''FROM'ST ------------------ String with blanks SQL>