>Thanks, everyone for your help. As some of you pointed out, I need to do this without there being a value in the field.
> Sergey, your code:
>? -AT(SET("Point"), PADL(MyField1,20)) % 20
>does exactly what I need. That is a brilliant solution!
> The link entitled "How to check if variable is Integer" says "FoxPro doesn't provide a direct way to check if variable is integer." TYPE() has always worked fine for me, even for variables.
>h = 0
>? TYPE('h') && Yields 'N'
>
>
>Jerry
It doesn't tell you if the field is an Integer, only that it is numeric.
If it's not broken, fix it until it is.
My Blog