>Hello,
>
>I need to know the size of fields, and I use FSIZE() for this. THis works fine, for example when a field is N(10), it returns 10. Now I have a table where a field is Integer (I) and FSize() returns 4, although the actual length of the field is 10 digits. So I want to get 10 when the field is an integer. How can I find this out?
>Thanks for help in advance!


You will get 4 with an Integer type field because an integer is store as a 4-byte binary value. If you want the number of digits stored in a integer type field you might try Len(AllTrim(Str(fieldname))). This will get the number of digits.

Hope this helps.