>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?
>TIA,
>Pete Adams

---

1. You can use

ISDIGIT()

function to check each character in the character field.

2. You can conver value in the character field to a number than back to character and compeare with source

ALLTRIM(STR(VAL(Myfield))) == ALLTRIM(Myfield)