Hi, I have a table that has random spaces appended to random varchar values. ( that's just a FOL ). I would like to run a procedure against the table and trim each varchar value "in place" so that, after running the procedure on a table, I could be assured that all cells are correctly trimmed.
i.e. trim_all_cells_in_table( 'DB.DBA.MY_TABLE' ); What's the correct way to do this? Iterate over the cursor and write in-place? Some of these tables have 10s of millions of rows so performance is definitely an issue. Thanks! A -- Aldo Bucchi skype:aldo.bucchi http://www.univrz.com/ http://aldobucchi.com/ PRIVILEGED AND CONFIDENTIAL INFORMATION This message is only for the use of the individual or entity to which it is addressed and may contain information that is privileged and confidential. If you are not the intended recipient, please do not distribute or copy this communication, by e-mail or otherwise. Instead, please notify us immediately by return e-mail.
