Hi, Isn't this a bug about trim both.
select trim(both '<BR/>' from '<BR/>ROI Engineering Inc.'); btrim --------------------- OI Engineering Inc. (1 row) "R" is missing? How? version ------------------------------------------------------------------------- PostgreSQL 8.0.15 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 Thank you! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql