I have a strange one. I'm trying to remove what appears to be spaces out of field with a datatype number. I look at the field in DOS using debug mode and see that there are hex 20's which means spaces right? Well when I perform a translate function to remove them they are still there.
I look at an sql dump and those spaces appear to be many different characters.
Why would I get two different results, one using dump and the other using debug?