How to convert numbers saved as characters into digits.
Is there any Query instruction to convert Characters into Digits? I'm trying to link 2 files, and one of the fields is character in one file and digits in the other, so I can't link them. For example: 00877874 is saved as character in file 1 and is saved as digits in file 2. Thanks for the help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!