replace syntax to remove the extra spaces in the column for a table

update table_name set column_name=replace(replace(DEA, CHR(10),''), CHR(13),'');

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

WIP Tables with description

  Table Name Description     WIP_ACCOUNTING_CLASSES stores accounting flexfield information for standard discrete jobs, non-standard asset j...