>

IF EMPTY(m.id) OR ISNULL(m.id) OR NOT LEN(CHRTRAN(m.id," ",""))=8

>
>The above code works well. But, I need to also check to see if it's all numeric too (0-9), can not have any alpha. I tried the below code but won't work. The field person.id is character and so is m.id. How to do about this?
>
>

BETWEEN(m.id,VAL(CHR(48)),VAL(CHR(57)))

>
>I may not need this because I have "99999999" as for the InputMask of the form. It's just that there's some alpha in the TEST data, but once going LIVE, I don't think I will need this... agreed?
>
>Chuck

Or you could do...

Len(ChrTran(m.id,'0123456789',''))=0

Will