How to remove new line characters from the end of a field in Teradata
Hi, We have a table where we have 'New Line Characters(Carriage Return)' at the end of many fields which is unreadable by the downstream system.We need to remove all the 'New Line Characters' from the end of all the fields.Can we use trim function/UDF to achieve this?Any other effective way to achieve this?