Technically, I think that the fastest way to get rid of the unicode junk would be to cast it to VARCHAR. . . obviously this would remove any unicode data from the string that you might actually want.