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-
