J B wrote:
Guys,
I have a table that has various fields that have whitespace in the
values. I'd like to roll through and strip the left and right whitespace
out of all fields that contain strings.
Is there any easy way to do this?
Thanks!
JB
"trim" will strip the whitespace from both sides. ltrim and rtrim are
front/back specific.
select '-'||trim(' asdf ')||'-';
?column?
----------
-asdf-
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
