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-