>Hi all,
> I'm looking for a relatively easy way to identify if a character field contains only numbers. My application is testing for valid/real postal addresses and one of the checks I'd like to make is if the field contains nothing but numerical data. Can anyone point the way?
VAL('1'+cPostalField) >= 10^(LEN(cPostalField)) works if the characters '^' and '*' are illegal, as would be the case with a mask of '9' or '#' characters.