>Goodmorning Jos:
>
>Thak you for your kind reponse. With the IF statement, I want to check if variable mCharacters contains any of the alphabetic letters. If it does then, I want to remove the first two characters, which are the position that could potentially have alphabectic characters, so that all that is left are numbers. This field has been declared as a Character field.
If the letters can only appear in the first two places:
#DEFINE AllLetters "ABCDEFGHIJKLMNOPQRSTXYZ"
if substr(mCharacters, 1, 1) $ AllLetters;
or substr(mCharacters, 2, 1) $ AllLetters
endif
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)