I don't know it works or not:
You can try to put in "Functions and Expressions:" in View Designer as
Your_Field_Number_A as Num_A
So that, the field name is changed into Num_A in creating the view that matching with the notation criteria of VFP... of course, if you have administrative right on SQL, it is better to rename the field name la...
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************