0 - 2 of 2 tags for translate

We have some old tables which has Unicode data(Japanese, Chinese, Korean etc..)  but with table defination as Latin for all columns, Which shows in BO report as Junk/ Unreadable character. Now we are trying to add new columns with character set as Unicode using alter statements. The approach we are following is

I want to replace all of the whitespace and non alphanumeric characters in a string. It seems like some form of the following should work: