I need to replace any any alpha characters in an ACE report with specific numbers.
A,B,C = 1; D,E,F = 2 etc.
Records can have more than one alpha.
I can use a CASE statement but that only handles a single instance of a letter, since as soon as the condition is met it moves on to the next record.
eg: "0123A456" becomes "01231456" just fine, but "012AB456" will only get turned into "0121B456" - the "B" doesn't get processed.
What I'd like to do is use a loop of some sort to keep looping through the CASE until all the letters are replaced.
Field is only 8 char long, so loop needs to run a maximum of 8 times.