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

On 2009-01-21, Wm.A.Stafford  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?