The Way to Character to Number, Number to Character Is SQL

摘要

It's going to happen. It's bound to happen. Sometime during your work with data, you'll have to take data in some form and turn it into something else. For you old-timers who can remember back to pre-BIF (built-in function) times in RPG, how many of you wrote your own subroutines full of MOVE/TEST statements to transform a character field into a number and visa-versa? Ah, the good old days. Thankfully, they are gone.