Ok...

So my field earlier had two ASCII characters in them and I was able to use the REPLACE() function to get rid of them.

I have another field that has a bunch of different ASCII characters in them. Using this link, I can see what each one is:

http://www.asciitable.com/

I then Googled, "How to get rid of ASCII characters TSQL" and get a bunch of hits back. I am currently trying to use this function here:

http://www.sqlservercentral.com/Forums/Topic1001736-391-1.aspx

And it doesnt work, unless I am calling/using it wrong, I am passing my code in as the following:

SELECT dbo.RemoveNonASCII(t.OffensiveColumn) AS RemovedASCII

FROM table t

I'm not sure if I am doing something wrong, or if there is a better way to get rid of a variety of ASCII characters in a single column???

Any feedback will be greatly appreciated!!

Thanks Again...