Joined: 04 Dec 2006 Posts: 44 Location: Pune,India
The requirement is to check for a non numeric value in a field.
Please tell me which options are available
for eg:- A is an alphanumeric field.
I need to check whether it is having a non numeric value.
Suppose you are having an A5 field which contains numeric value
1 #I (A5)
if #I= MASK(99999) --> this will verify that the field is numeric or not
The other way you can do this is by checking every byte against the alphanumeric character,only if the special characters should not be present in the field.Otherwise you should have to add that check as well,byte by byte.