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

You can use something like

select ltrim(string, ' ');

and

select rtrim(string, ' ');

Thanks,
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 10/28/06, J B <jbwellsiv(at)gmail(dot)com> 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
>