>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)
--sb--