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.
Thank you Jos.
>Henry, none of the lines are wrong in any obvious way - provided mCharacters and mOldID exist and IncompleteList is an object with ID as a property. What are you trying to do with this code snippet?
>
>
>>Hi all:
>>
>>The following code does not want to work.
>>
>>
IF mCharacters = ("ABCDEFGHIJKLMNOPQRSTXYZ")
>> mID = alltrim(SUBSTR(mOldID,3,7))
>> ELSE
>> mOldID = IncompleteList.ID
>> ENDIF
>>
>>Where am I going wrong? TIA.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons