Tags for spaces
remove "whitespaces" and "." in a string
I have a table with a column of alpha-numeric data the currently has multiple (periods) "." and spaces in the string. I need to remove them for data compare in another DBMS. I have searched not only through this forum but others as well and can not seem to find the solution.
teradata sql remove trim characters spaces ltrim rtrim