SCAN for Numeric

[Guest.Visitor]

Use the opcode "CHECK" Chris

---

Code

[sgraves@summitpet.com]

Can you scan a numeric field for characters. I have just used a move from a character field to numeric field and I need to verify that the character field or numeric field only contains 0-9. thanks

[Matt.Tyler]

Use the testn opcode. Indicator LO = character field only contains numerics, LO = character field contains leading blanks and numerics only, EQ = character field only contains blanks. If the indicators are not on then there is non-numeric data. This is really useful when you have negative data with in a character field (i.e., value '775N' is actually is -7755). Just scanning for numeric numbers is not going to cover you in this case. Matt