Re: Stripping empty space from all fields in a table?

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-