Monthly Archives: October 2014

How to clean text based on ASCII range

Ok, how can I clean my text with simple English symbols, let’s say from CHAR(10) to CHAR(125). In other words, if I have text “‘1,2,3…,4,5,•,6,ÿ,7′”, how can I get “1,2,3,4,5,,6,,7” ? Here is my approach: if text within 64K, it takes less than 1 second. … Continue reading

Posted in SQL | Tagged | Leave a comment