View previous topic :: View next topic
|
Author |
Message |
prasanth_urs
New User
Joined: 04 Dec 2006 Posts: 44 Location: Pune,India
|
|
|
|
Hi all,
Please help!
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.
Thanks
Prasanth |
|
Back to top |
|
|
beruoist
New User
Joined: 14 Nov 2007 Posts: 70 Location: mumbai
|
|
|
|
You can use mask
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.
Guys,Please comment if i am wrong |
|
Back to top |
|
|
|