The SQL function trim(both from …)
removes space characters from the end (right side) of a string. The keywords both from
are optional.
SELECT TRIM(BOTH FROM ' traveling spaces ')
FROM …
The result of the example is the text 'traveling space'
with the spaces removed from both ends.
Options: trim( [ [leading|trailing] [<char>] FROM ] …)
Only at on end: trim(leading from …)
, trim(trailing from …)
Another character: trim(<char> from …)
From both ends (default): trim(…)
The trim()
function, including the both from
keywords, is defined in ISO/IEC 9075-2:2023 as mandatory feature E021-09, “TRIM
function”.
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Twitter or RSS to gradually catch up and to keep modern-sql.com on your radar.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »