Hi,
I need to trim whitespace off of a whole column and replace the existingvalues with the trimmed ones.
This isn't working
update mytable set id = trim(id);
I'm not sure of the correct syntax. Help appreciated.
Mike