On 2009-01-21, Wm.A.Stafford <stafford(at)marine(dot)rutgers(dot)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?