从SQL字段中删除前导0的算法?

I just came across the interesting problem of trying to trim the leading zeroes from a non-numeric field in SQL. (Since it can contain characters, it can't just be converted to a number and then back.)I just came across the interesting problem of t