Yuri -

If I have a field named X in a table which is character, then value of TYPE('X') is "C", whether or not X is .NULL. Please note that this differs from VARTYPE(X), which returns "X" in both VFP6 and VFP7.

The big difference is that when Excel cell.value's are read in VFP7, they appear as .NULL., whereas they were "" [space(0)] in VFP6.

- George

In addition to my previous message.
It is interesting that TYPE(x) returns nothing in VFP7. Looks like a bug in VFP7. At least type() must return something!