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

["Shoaib Mir" <shoaibmir@xxxxxxxxx>]

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@xxxxxxxxx> 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