Re: Check whether a field is Numeric or not
Posted: Thu Aug 30, 2012 8:02 pm
I think the values for 2 and 3 are what they should be, but, (and you can see it is a big one) I now suspect you are right about the whole thing.
Nik, if you do it without the other stuff (the REVERSE and LEADING SPACE, as set out previously) then you will be letting bad data through.
You have ALL SPACE for your INSPECT, where you need LEADING (after the REVERSE, because "trailing space" is OK but leading or embedded is no, but you can't put TRAILING on the INSPECT).
Only the 9 is valid, yet with your INSPECT all would be accepted.
Nik, if you do it without the other stuff (the REVERSE and LEADING SPACE, as set out previously) then you will be letting bad data through.
You have ALL SPACE for your INSPECT, where you need LEADING (after the REVERSE, because "trailing space" is OK but leading or embedded is no, but you can't put TRAILING on the INSPECT).
9
1
2
3
4
1
2
3
4
Only the 9 is valid, yet with your INSPECT all would be accepted.