Remove Non Ascii Characters from a column in a table

[dhoward007]

Is there a way to run an update in SQL using some function to remove any non ascii characters from the column? We are loading data from AS400 and somtimes there are extra characters and we need to remove them.

 

[johnherman]

If you do not get a solution for this via the database, there are some operations we can perform on the flat file at the operating system level before loading; let me know if you need them; I have marked this thread.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[dhoward007]

That might do the trick.. If you don't mind passing it along.. If that doesn't work, I will probably create some kind of update statement to look for certain characters and remove them..

Thanks for the help.