Re: removing leading and trailing blanks from every row in a table

On 2009-01-21, Wm.A.Stafford <stafford@marine.rutgers.edu> wrote:
> I need a procedure to remove leading and trailing blanks from column of
> every row in a table.  I would like to pass the table name as a
> parameter and have the procedure do the rest.  Does something like this
> already exist?  Is it even possible?

the sql to do this is

UPDATE tablename SET columnname=TRIM( columnname );

Do you really need a function?