Tags for characters
Problem with Polish special characters in WHERE clause
Hi All, I have the following problem with Polish special characters. I've got 2 tables:
Polish special characters
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