user9026725 wrote:Hm. That can happen if your strings contain blanks at the beginning. How about if you show us some samples of your data first? So that we can stop guessing.
The last suggestion updated all fields with 0.
Is there another way to tell it you just want to drop the letter off the end?That should be even more simple.
this simply takes all digits from the string.
this removes the last character if it is not a digit.