>

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

If m.id is character the above will generate an "operator/operand mismatch" error. However, BETWEEN(m.id, '0', '9') works fine. There's also the ISDIGIT() function to test if a particular character is numeric or not in a string.