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@gmail.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