Checking for numerics in character field

[dford@pmi.delta.org]

Checking for numerics in character field

I believe Ken's solution works even in the case that padshore@optonline.net mentions. See below code ...

---

Code

[padshore@optonline.net]

Checking for numerics in character field

Hi everybody - I'm hoping someone knows the answer to this problem. I need to select records from a file based upon numerous criteria, of which one of the criteria is a 9 byte CHARACTER field containing ONLY numeric values (0 through 9 for ALL 9 bytes). I know I could sub-string each byte out and check it that way, but if anyone knows of another method (irrespective of the size of the field) it would be much appreciated Thanks in advance Alan

[padshore@optonline.net]

Checking for numerics in character field

DUH - You fool (Thats me speaking to me) I misunderstood/misread the way TRANSLATE worked. Sorry Ken Alan